[Veritas-bu] Unable to restore DBs on SQL2005 cluster
2007-03-19 07:07:59
Subject: |
[Veritas-bu] Unable to restore DBs on SQL2005 cluster |
From: |
Steven.Jenner at uk.telstra.com (Jenner, Steven) |
Date: |
Mon, 19 Mar 2007 11:07:59 -0000 |
Hi,
I am attempting to restore a DB using the Veritas SQL agent on a SQL
2005 cluster with no success. I have managed to restore both the MSDB
and Master Databases successfully (by running MSSQL in single user mode
for the Master and stopping SQL agent for the MSDB); but the non system
DB's are not playing.
The following error message is being displayed:
08:02:36 (508233.001) INF - Waiting for positioning of media id 000274
on server sn251170 for reading.
08:03:08 (508233.001) INF - Beginning restore from server sn251170 to
client BRY02880-SQL1.
08:03:16 (508233.001) The following files/folders were not restored:
DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>,
Message Text <[Microsoft][SQL Native Client][SQL Server]The operating
system returned the error '5(error not found)' while attempting
'OpenForRestore' on 'g:\FTData\sysfttestCMS\SQL.HDR'.> DBMS MSG -
<[Microsoft][SQL Native Client][SQL Server]File 'sysft_testCMS' cannot
be restored to 'g:\FTData\testCMS'. Use WITH MOVE to identify a valid
location for the file.> DBMS MSG - <[Microsoft][SQL Native Client][SQL
Server]Problems were identified while planning for the RESTORE
statement. Previous messages provide details.> DBMS MSG -
<[Microsoft][SQL Native Client][SQL Server]RESTORE DATABASE is
terminating abnormally.> ERR - Error found executing
08:03:16 (508233.001) UTF -
/BRY02880-171.MSSQL7.BRY02880-SQL1\SQL1.db.test_cms.~.7.001of001.2007031
4093830..C
08:03:16 (508233.001) UTF -
/BRY02880-171.MSSQL7.BRY02880-SQL1\SQL1.db.test_cms.~.7.001of001.2007031
4093830..C
08:03:17 (508233.001) UTF -
/BRY02880-171.MSSQL7.BRY02880-SQL1\SQL1.db.test_cms.~.7.001of001.2007031
4093830..C
08:03:17 (508233.001) UTF -
/BRY02880-171.MSSQL7.BRY02880-SQL1\SQL1.db.test_cms.~.7.001of001.2007031
4093830..C
08:03:17 (508233.001) UTF -
/BRY02880-171.MSSQL7.BRY02880-SQL1\SQL1.db.test_cms.~.7.001of001.2007031
4093830..C ERR - Error in VDS->Close: 0x80770004. The text follows:
CONTINUATION: - An abort request is preventing anything except
termination actions. INF - OPERATION #1 of batch C:\Program
Files\VERITAS\NetBackup\DbExt\MsSql\test_cms.bch FAILED with status 1.
Elapsed time = 632(632) seconds. 08:03:17 (508233.001) Status of restore
from image created Wed Mar 14
09:31:47 2007 = client process aborted
I have attempted to perform the restore by using the Move template
option and renaming the file names, but again to no avail.
As I have had no issues in the past with regular MSSQL restores I
presume that this is probably a SQL2005 or cluster issue but am unsure
as to where to start after working on this for several days.
I would be grateful if anyone had any ideas or instructions regarding
restoring SQL 2005 clusters.
My environment is as follows:
Veritas Master & Media servers & client running Enterprise v5.1MP6
Thanks in advance,
Steve.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070319/9f7b36ee/attachment.htm
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] Unable to restore DBs on SQL2005 cluster,
Jenner, Steven <=
|
|
|