How to restore SQL data base to another server.
Updated: 22 May 2010 | 3 comments
This issue has been solved. See solution.
Hi Folks!!
Please guide me in restoring SQL data base from master server to other server .(both are in same LAN)
Thanks in advance !!
discussion Filed Under:
Comments
Restore sql database
Hi
Follow this step by step:
DOCUMENTATION: Performing a Database Move to the same SQLHOST or to an alternate HOST
http://seer.entsupport.symantec.com/docs/273567.htm
Of course, the destination server should have netbackup installed, and is allowed to browse images.
-Rajeev
"Unix IS user friendly... It's just selective about who its friends are"
8/13/2009 1:59:44 PM -
8/13/2009 1:59:44 PM - media TD222S required
8/13/2009 2:00:17 PM - restoring image xxxxxxxx_1249394006
8/13/2009 2:00:20 PM - started process bptm (6912)
8/13/2009 2:00:20 PM - mounting TDxxxx
8/13/2009 2:00:31 PM - connected
8/13/2009 2:01:23 PM - mounted; mount time: 00:01:03
8/13/2009 2:01:24 PM - positioning TDxxxx to file 298
8/13/2009 2:03:14 PM - positioned TDxxxxx; position time: 00:01:50
8/13/2009 2:03:14 PM - begin reading
8/13/2009 2:20:02 PM - Error bptm(pid=7684) The following files/folders were not restored:
8/13/2009 2:20:02 PM - Error bptm(pid=7684) UTF - /xxxxxxxxxx.MSSQL7xxxxxxxxxx.db.xxxxxxxxxx9.~.7.001of001.20090804215257..C
8/13/2009 2:20:02 PM - Error bptm(pid=7684) UTF - /xxxxxxxxxx.MSSQL7xxxxxxxxxx.db.xxxxxxxxxx9.~.7.001of001.20090804215257..C
8/13/2009 2:20:02 PM - Error bptm(pid=7684) UTF - /xxxxxxxxxx.MSSQL7xxxxxxxxxx.db.xxxxxxxxxx9.~.7.001of001.20090804215257..C
8/13/2009 2:20:02 PM - Error bptm(pid=7684) UTF - /xxxxxxxxxx.MSSQL7xxxxxxxxxx.db.xxxxxxxxxx9.~.7.001of001.20090804215257..C
8/13/2009 2:20:02 PM - Error bptm(pid=7684) UTF - /xxxxxxxxxx.MSSQL7xxxxxxxxxx.db.xxxxxxxxxx9.~.7.001of001.20090804215257..C
8/13/2009 2:20:03 PM - restored image xxxxxxx_1249394006 - (network connection timed out(41)); restore time 00:19:46
8/13/2009 2:20:08 PM - end Restore; elapsed time: 00:20:26
8/13/2009 1:59:43 PM - 1 images required
Hi,
8/13/2009 1:59:42 PM - begin Restore
the restore failed to recover the requested files(5)
I can see the mdf and ldf files in the destination location. but unable to attach.
KIndly assist me in fixing this issue.
Pleasae let me know if any attributes needs to be changed in netbackup .
When doing SQL restores, you
When doing SQL restores, you need to increase CLIENT_READ_TIMEOUT on the media server drastically - make it at least 7200. (Remember to drop down again after successful restore.)
Also have a look at this TechNote on how to troubleshoot SQL restore issues:
http://seer.entsupport.symantec.com/docs/277084.htm
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links
Would you like to reply?
Login or Register to post your comment.