Veritas-bu

[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>