Urgent-Cannot Restore Sql(2005) Db whit move batch
hello all,
i want to restore SQL 2005 to another SQL server(With move Script-I cant restore to the Orignal Sqrver.)
After i configured the batch file i open the NetBackup SQL Client >Manage Script files>select the script i cerated and configured and
start the restore.
after 1 minute i see in the Event Viewer this manage:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 18210
Date: 11/03/2010
Time: 23:38:43
User: MADA\Administrator
Computer: serverDB
Description:
BackupMedium::ReportIoError: read failure on backup device 'VNBU0-2084-484-1268343517'. Operating system error 995(error not found).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 22 47 00 00 10 00 00 00 "G......
0008: 0a 00 00 00 43 00 52 00 ....C.R.
0010: 4d 00 44 00 42 00 2d 00 M.D.B.-.
0018: 49 00 4e 00 54 00 00 00 I.N.T...
0020: 00 00 00 00 ....
the script file(I marked the Source & Destination Sql Server):
#
# This is a template for the database MOVE command.
#
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
#
# Replace the database name in the following line with the name of the database that you
# want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
#
#DATABASE "WSS_80"
#
# Replace the file path <D:\SQL\MSSQL.1\MSSQL\DATA\WSS_Content_80.mdf>
# with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
# The target of the MOVE keyword must be "WSS_80".
MOVE "WSS_80"
#TO "D:\SQL\MSSQL.1\MSSQL\DATA\WSS_80.mdf"
#
#
# Replace the file path <D:\SQL\MSSQL.1\MSSQL\DATA\WSS_80_log.LDF>
# with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
# The target of the MOVE keyword must be "WSS_80_log".
MOVE "WSS_80_log"
TO "D:\SQL\MSSQL.1\MSSQL\DATA\WSS_80_log.LDF"
#
# The following image is type: Full
NBIMAGE "serverdb.MSSQL7.MOSSDB.db.WSS_80.~.7.001of001.20100309183043..C"
SQLHOST "serverdb-int" Destination sql server
NBSERVER "BACKUPSRV"
BROWSECLIENT "serverdb" Source Sql Server
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE
What I'm doing Wrong?
Comments
All 'urgent' calls should be
All 'urgent' calls should be logged with Symantec Support directly.
All list members have full day-time jobs that take the time to assist fellow users.
About you script - you have told the agent that you want to move the database, but not where to:
MOVE "WSS_80"
#TO "D:\SQL\MSSQL.1\MSSQL\DATA\WSS_80.mdf"
(move location commented out)
logs move seems fine:
MOVE "WSS_80_log"
TO "D:\SQL\MSSQL.1\MSSQL\DATA\WSS_80_log.LDF"
Please ensure that you have dbclient log on SQL host for further troubleshooting.
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links
Marianne, thanks for the
Marianne,
thanks for the help.
I restored the DB throuth the SQL Backup ,but i want to try to backup The Db to other SQL server With The NetBackup agent.
When I open the Netbackup MS SQL Client(On the Destination Server) > Restore SQL Server Objects>
At the SQL Host entered the sql server which i want to restore to
At the Source Client entered the SQL server which i want to restore from
but i get to error massage:
Error encountered trying to read database image
And:
You may have received this error if you do not have access rights to backup
images created for
I added the file no.restrictions file on the master server in the netbackup\db\altnames
directory.
If i do this operation from the master server i can create the Scrip file but when i opened the file i see that the sqlhost and
the browseclient is the same server(the source server).
can i change it menually to the server which i would like to restore the DB to?
Whay i still gets the error messeges if i added the No.Restrictions file
I will appreciate for any help
SQL restore must be initiated
SQL restore must be initiated from the destination client.
Check that there's no txt extention at the end of filename No.Restrictions. (You do have the N and R in upper case?)
Also check that browse and restore is allowed for source and destination client in Host Properties -> Master server -> Client Attributes.
If the client names do not appear in the list, add them and check that "Allow Both" is selected under Browse and restore ability for each of the client names.
You did not mention your NBU version - there was a bug in certain NBU 5.1 versions:
http://seer.entsupport.symantec.com/docs/278914.htm
http://seer.entsupport.symantec.com/docs/287846.htm
http://seer.entsupport.symantec.com/docs/279820.htm
How to manually create a SQL database restore script when having issues creating the restore script using NetBackup Microsoft SQL client GUI:
http://seer.entsupport.symantec.com/docs/271275.htm
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links
thanks for your help
thanks for your help
Another queston
How can i allow two different policys to run on the same backup media in the same time?
Would you like to reply?
Login or Register to post your comment.