Veritas-bu

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

2007-03-22 05:50:05
Subject: [Veritas-bu] Unable to restore DBs on SQL2005 cluster
From: Steven.Jenner at uk.telstra.com (Jenner, Steven)
Date: Thu, 22 Mar 2007 09:50:05 -0000
Hi,

 

Apologies for not responding to some of the replies but I can confirm
that the issue has now been resolved. It was due to an issue with the
Full Text Catalogs on the DB. By renaming the catalog or removing
entirely I was able to restore the DB using the same batch script as
previously used. Alternatively I could provide a new name and location
for the full text catalog as described below:

 

Etrack Incident = ET383843 ET405561

Description: 
   This patch enables general backup and restore support for SQL Server
2005.
   Since this patch is released. New SQL Server features that require
changes
   to the SQL backup API or the SQL language are not supported until
NetBackup
   6.0.  The minimal level of SQL Server 2005 supported by this patch is
the
   June 2005 Community Technical Preview. 

Additional Notes: 
   Consistent with new functionality provided under SQL Server 2005,
this patch
   does support inclusion of full text catalog with database backups.
However,
   there are two restrictions placed on SQL Server 2005 full text
catalog backups.
   
   (1) If the SQL Server 2005 database contains a full text catalog,
then the
   backup will not be backed up using a snapshot method. If an advanced
client
   policy is selected for backup, then the database will be backed up
using the
   standard backup method.
   
   (2) A database move attempted on a SQL Server 2005 database that
contains a
   full text catalog, will fail with a message such as the following:
   
   DBMS MSG - <[Microsoft][SQL Native Client][SQL Server]File
   'sysft_HerCatalog' cannot be restored to 'C:\Program Files\Microsoft
SQL
   Server\MSSQL.1\MSSQL\FTData\HerCatalog'. Use WITH MOVE to identify a
valid
   location for the file.>
   
   This indicates that SQL Server 2005 expects to be provided a new
location
   for the full text catalog directory. To resolve this issue, update
the move
   script by providing a valid directory for the full text catalog. For
   example, to specify that the full text catalog named HerCatalog
should be
   placed in directory "c:\NewLoc\HerCatalog\" provide the following
lines in
   the move script:
   
   MOVE "sysft_HerCatalog"
   TO  "C:\NewLoc\HerCatalog\"
   
   After this update has been made, rerun the move script to carry out
the move
   operation.

 

Thanks again for all of the replies and assistance with this one.

 

Cheers,

 

Steve.

  _____  

From: veritas-bu-bounces at mailman.eng.auburn.edu
[mailto:veritas-bu-bounces at mailman.eng.auburn.edu] On Behalf Of Jenner,
Steven
Sent: 19 March 2007 11:08
To: veritas-bu at mailman.eng.auburn.edu
Subject: [Veritas-bu] Unable to restore DBs on SQL2005 cluster
Importance: High

 

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/20070322/0cd99085/attachment.html

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