SQL Server Performance Forum – Threads Archive

differential backup n restore

hi gurus, The possibilities to restore differential backup to another difference server from the original database backup server. Situation;
there is 2 system database backup (master & msdb)
and 3 user’s database (etc; A, B, C) 1-scripts backup using sql server 2005 directly backup to tape as full backup only on sunday at 3:00 am.
2-scripts backup using sql server 2005 directly backup to tape as differential backup on everyday at 12:01 am. my colleague told me that when he tried to restore, there is an error mentioned that cannot restore on difference server name. here are the scripts
1- for daily (differential)
#######################################################################################
BACKUP DATABASE [A] TO TAPE = N’\.Tape0′ WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N’A-Daily SET01-Differential Database Backup’, SKIP, REWIND, NOUNLOAD, STATS = 10
GO BACKUP DATABASE TO TAPE = N’\.Tape0′ WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N’B-Daily-Differential Database Backup’, SKIP, REWIND, NOUNLOAD, STATS = 10
GO BACKUP DATABASE [C] TO TAPE = N’\.Tape0′ WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N’C-Daily-Differential Database Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO BACKUP DATABASE [master] TO TAPE = N’\.Tape0′ WITH NOFORMAT, NOINIT, NAME = N’master-Full Database Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO BACKUP DATABASE [msdb] TO TAPE = N’\.Tape0′ WITH NOFORMAT, NOINIT, NAME = N’msdb-Full Database Backup’, SKIP, REWIND, UNLOAD, STATS = 10
GO
####################################################################################### 2-for full backup(weekly)
#######################################################################################
BACKUP DATABASE [A] TO TAPE = N’\.Tape0′ WITH NOFORMAT, INIT, NAME = N’A-Full Database Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO BACKUP DATABASE TO TAPE = N’\.Tape0′ WITH NOFORMAT, NOINIT, NAME = N’B-Weekly-Full Database Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO BACKUP DATABASE [C] TO TAPE = N’\.Tape0′ WITH NOFORMAT, NOINIT, NAME = N’C-Weekly-Full Database Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO BACKUP DATABASE [master] TO TAPE = N’\.Tape0′ WITH NOFORMAT, NOINIT, NAME = N’master-mingguan-Full Database Backup’, SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO BACKUP DATABASE [msdb] TO TAPE = N’\.Tape0′ WITH NOFORMAT, NOINIT, NAME = N’msdb-mingguan-Full Database Backup’, SKIP, REWIND, UNLOAD, STATS = 10
GO
####################################################################################### maybe we have implement wrong scripts or wrong backup procedure. please help me out.
tq

You need to post the exact RESTORE statements he used and the exact error. You should be able to restore using the WITH MOVE option to the new server. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

…also check books online for more information on what has been referred above. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>