Veritas-bu

[Veritas-bu] Unable to restore DBs on SQL2005 cluster

2007-03-20 08:20:58
Subject: [Veritas-bu] Unable to restore DBs on SQL2005 cluster
From: simon.weaver at astrium.eads.net (WEAVER, Simon (external))
Date: Tue, 20 Mar 2007 12:20:58 -0000
Are you doing the restore by the virtual name?
Assume you have the logging set to max - must give something in the log file
to indicate the reason of failure.
 
Permissions set correctly?
 
 

Regards

Simon Weaver
3rd Line Technical Support
Windows Domain Administrator 

EADS Astrium Limited, B23AA IM (DCS)
Anchorage Road, Portsmouth, PO3 5PU

Email:  <mailto:Simon.Weaver at Astrium-eads.net> Simon.Weaver at 
Astrium-eads.net

-----Original Message-----
From: Jenner, Steven [mailto:Steven.Jenner at uk.telstra.com] 
Sent: 20 March 2007 10:57
To: Dennis Naidoo; veritas-bu at mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] Unable to restore DBs on SQL2005 cluster



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.20070314093
830..C

 08:03:16 (508233.001) UTF -
/BRY02880-171.MSSQL7.BRY02880-SQL1\SQL1.db.test_cms.~.7.001of001.20070314093
830..C

 08:03:17 (508233.001) UTF -
/BRY02880-171.MSSQL7.BRY02880-SQL1\SQL1.db.test_cms.~.7.001of001.20070314093
830..C 

08:03:17 (508233.001) UTF -
/BRY02880-171.MSSQL7.BRY02880-SQL1\SQL1.db.test_cms.~.7.001of001.20070314093
830..C 

08:03:17 (508233.001) UTF -
/BRY02880-171.MSSQL7.BRY02880-SQL1\SQL1.db.test_cms.~.7.001of001.20070314093
830..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 
______________________________________________________________________




This email (including any attachments) may contain confidential and/or 
privileged information or information otherwise protected from disclosure.
If you are not the intended recipient, please notify the sender immediately, do 
not copy this message or any attachments and do not use it for any purpose or 
disclose its content to any person, but delete this message and any attachments 
from your system.
Astrium disclaims any and all liability if this email transmission was virus 
corrupted, altered or falsified.
---------------------------------------------------------------------
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070320/352a3787/attachment.html

<Prev in Thread] Current Thread [Next in Thread>