Hi Dennis,

 

Thanks for the reply.

 

I can confirm that the directory I am attempting to restore the date to
does exist and is a resource located on the cluster.

 

Checking both the bphdb and dbclient logs yields no additional
information. Unfortunately the SQL cluster config was implemented by and
is supported by a third party (my customer) and I purely supply managed
backups therefore identifying if this is a MSSQL configuration issue is
proving difficult.

 

Any additional suggestions much appreciated.

 

Regards,

 

Steve.

 

  _____  

From: Dennis Naidoo [mailto:dnaidoo at stortech.co.za] 
Sent: 20 March 2007 09:06
To: Jenner, Steven; veritas-bu at mailman.eng.auburn.edu
Subject: RE: [Veritas-bu] Unable to restore DBs on SQL2005 cluster

 

Hi

 

2 things you can check:

Make sure that the directory you are restoring into exists, eg.
'g:\FTData\sysfttestCMS, 'g:\FTData.  The directories cannot be created
by the restore.

IF SQL is in the cluster, and the G:\ drive is an alternate location to
the original, then G:\drive has to be a resource in the cluster as well.

 

Also check the bphdb, and dbclient logs.

 

Dennis

 

  _____  

From: Jenner, Steven [mailto:Steven.Jenner at uk.telstra.com] 
Sent: 19 March 2007 13:08
To: veritas-bu at mailman.eng.auburn.edu
Subject: [Veritas-bu] Unable to restore DBs on SQL2005 cluster

 

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 
______________________________________________________________________


______________________________________________________________________
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/20070320/dfb0e011/attachment-0001.htm