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:[EMAIL PROTECTED]> [EMAIL PROTECTED]
-----Original Message-----
From: Jenner, Steven [mailto:[EMAIL PROTECTED]
Sent: 20 March 2007 10:57
To: Dennis Naidoo; veritas-bu@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:[EMAIL PROTECTED]
Sent: 20 March 2007 09:06
To: Jenner, Steven; veritas-bu@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:[EMAIL PROTECTED]
Sent: 19 March 2007 13:08
To: veritas-bu@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
_______________________________________________
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
