Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rudba
Constraint Violating Yak Guru
415 Posts |
 Posted - 2009-05-08 : 16:54:28
|
| Hello Everybody,I have following script to full database backup, differential database and transaction log backup.I can restore full database backup but i can not restore differential database. How do i restore differential database? My full backup script runs a week and differential database runs twice a week. I got the following errower while restore differential database:Msg 3117, Level 16, State 1, Line 1The log or differential backup cannot be restored because no files are ready to rollforward.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.--Full BackupBACKUP DATABASE [dbPCInfo] TO DISK = N'D:\Db\MyDb_Full.BAK' WITH NOFORMAT, NOINIT, NAME = N'MyDb-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GO--Diff DifferentialBACKUP DATABASE [MyDb] TO DISK = N'D:\Db\MyDb_05062009_Diff.BAK' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'MyDb-Differential Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GO--Transaction Log BackupBACKUP LOG [dbPCInfo] TO DISK = N'D:\Db\MyDb_05062009_.TRN' WITH NOFORMAT, NOINIT, NAME = N'MyDb-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GO--Restore Full BackupRESTORE DATABASE [dbPCInfo] FROM DISK = N'D:\Db\MyDb_Full.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10GO--Restore Differential BackupRESTORE DATABASE [MyDb] FROM DISK = N'D:\Db\MyDb_05062009_Diff.BAK' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10GO |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-08 : 18:03:36
|
| Restore Full Backup in NORECOVERY MODERestore Diff Backup with RECOVERY MODE. |
 |
|
|
|
|
|
|
|
How do i restore differential database backup