October 18, 2013 at 10:09 am
Hi I am looking to restore ad full and diff using this script:
RESTORE DATABASE LSS
FROM DISK = 'F:\For restore\Lss_backup_2013_10_13_000010_4544977\Lss_backup_2013_10_13_000010_4544977.bak'
WITH NORECOVERY
GO
-- Now restore the differential database backup, the second backup on
-- the MyAdvWorks_1 backup device.
RESTORE DATABASE LSS
FROM DISK = 'F:\For restore\Lss_backup_2013_10_13_000010_4544977\Lss_backup_2013_10_18_000012_9335308.dif'
WITH FILE = 2,
WITH RECOVERY
But MSSQL comes back with this kind of error (don't have exact output to hand):
Cannot find file ID 2 on device 'F:\For restore\Lss_backup_2013_10_13_000010_4544977\Lss_backup_2013_10_18_000012_9335308.dif'
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
The only reasons I could attribute to this in our setup is that the backup from source system is an 2k8r2 sp2 server whereas the destination of the restore is 2k8 but not on sp2 yet, or that winrar (which i used to split the larger full backup for transport) has somehow broken the full file so it doesn't see the dif (dif was not zipped). Yet the full seems ok restoring....
Or...that someone may have run a full between the full and dif files I am using and therefore broken the LSN chain? Yet to check this but the error to me does not make sense against this scenario....
Anyone help....or seen this before?
O and yes the file definatley exists!!!!
October 18, 2013 at 12:49 pm
Hi ben, 😀
select your msdb.dbo.backupset table to see what are your available backup sets.
Jonathan Bernardez Bernardez
___________________________________________________________
DBD. MCSA SQL Server 2012
October 18, 2013 at 1:27 pm
Are you absolutely sure it's file #2? SQL verifies a file before restoring it.
Check the backup file contents just to be sure:
RESTORE FILELISTONLY
FROM DISK = 'F:\For restore\Lss_backup_2013_10_13_000010_4544977\Lss_backup_2013_10_18_000012_9335308.dif'
Edit: Corrected backup file name.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
October 21, 2013 at 3:47 am
jonysuise (10/18/2013)
Hi ben, 😀select your msdb.dbo.backupset table to see what are your available backup sets.
Hi Jonathan, I am restoring on a different server so I presume that wouldn't apply??
October 21, 2013 at 3:48 am
ScottPletcher (10/18/2013)
Are you absolutely sure it's file #2? SQL verifies a file before restoring it.Check the backup file contents just to be sure:
RESTORE FILELISTONLY
FROM DISK = 'F:\For restore\Lss_backup_2013_10_13_000010_4544977\Lss_backup_2013_10_18_000012_9335308.dif'
Edit: Corrected backup file name.
Hi Scott, thanks for the reply, checked both, what am I looking for??
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply