July 20, 2016 at 3:35 pm
I am trying to restore a database but receiving the following error. Obviously i was testing with a Verify, but the error trying to execute the restore is the same.
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\{581F904B-119E-4717-8A49-078DBD172F6A}3'. Operating system error 2(The system cannot find the file specified.).
VERIFY DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3201)
I am running SQL Server backups using the "Full" Recovery Mode.
Windows Server/BackupAssist are also running imaging backups of the entire machine (it's a Virtual Machine). As best as i can tell, it is also running a FULL database backup everyday and adding it to the chain....which i believe is the {581F904B-119E-4717-8A49-078DBD172F6A}3 referred to in the error message.
How do i do a restore to any point in time that 'ignores' the 'imaging' backups?
Thanks!
July 20, 2016 at 4:12 pm
What's your RESTORE statement?
If you're using the GUI, rather don't. It's a pain for this reason. At best use it to script the restores.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2016 at 4:30 pm
Sunday night is a Full backup. each morning is a Diff.
since i am trying to restore to a particular date/time, i was initially using the GUI. then i was using the GUI to generate scripts. Below is the generated script from the GUI.
obviously the 1st RESTORE DATABASE is using the virtual FULL backup instead of my Sunday night FULL. the 2nd RESTORE DATABASE is using my morning DIFF.
USE [master]
RESTORE DATABASE [CDDB_Data_restoreTest] FROM DISK = N'{2D17E9BA-7A14-4835-9A0E-EF3DBF6FE6FE}3' WITH FILE = 1, MOVE N'CDDB_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\DATA\CDDB_Data_restoreTest.mdf', MOVE N'CDDB_Data_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\DATA\CDDB_Data_restoreTest.ldf', NORECOVERY, NOUNLOAD, STATS = 5
RESTORE DATABASE [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\DIFF\IMUADB01$IMUA_CDDB_CDDB_Data_DIFF_20160719_060000.bak' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_060500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_061000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_061500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_062000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_062500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_063000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_063500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_064000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_064500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_065000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_065500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_070000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_070500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_071000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_071500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_072000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_072501.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_073001.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_073500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_074000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_074500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_075000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_075500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_080000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_080500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_081000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_081500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_082000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_082500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_083000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_083500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_084000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_084500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_085000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_085500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_090000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_090500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_091000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_091500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_092000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_092500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_093000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_093500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_094000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_094500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_095000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_095500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_100000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_100501.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_101001.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_101501.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_102001.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_102500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_103000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_103500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_104000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_104500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_105000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_105500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_110000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_110500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_111000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_111500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_112000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_112500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_113000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_113500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_114000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_114500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_115000.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_115500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_120002.trn' WITH FILE = 1, NOUNLOAD, STATS = 5, STOPAT = N'2016-07-19T12:00:00'
GO
when i run this code i get the following errors:
Msg 3201, Level 16, State 2, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\{2D17E9BA-7A14-4835-9A0E-EF3DBF6FE6FE}3'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Msg 3136, Level 16, State 1, Line 3
This differential backup cannot be restored because the database has not been restored to the correct earlier state.
Msg 3013, Level 16, State 1, Line 3
RESTORE DATABASE is terminating abnormally.
Msg 4305, Level 16, State 1, Line 4
The log in this backup set begins at LSN 10972000000010500001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 4
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 5
The log in this backup set begins at LSN 10972000000010800001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 5
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 6
The log in this backup set begins at LSN 10972000000011100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 6
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 7
The log in this backup set begins at LSN 10972000000011400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 7
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 8
The log in this backup set begins at LSN 10972000000011700001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 8
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 9
The log in this backup set begins at LSN 10972000000012000001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 9
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 10
The log in this backup set begins at LSN 10972000000012300001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 10
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 11
The log in this backup set begins at LSN 10972000000012600001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 11
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 12
The log in this backup set begins at LSN 10972000000012900001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 12
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 13
The log in this backup set begins at LSN 10972000000013200001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 13
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 14
The log in this backup set begins at LSN 10972000000013500001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 14
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 15
The log in this backup set begins at LSN 10972000000013800001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 15
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 16
The log in this backup set begins at LSN 10972000000017100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 16
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 17
The log in this backup set begins at LSN 10972000000018400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 17
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 18
The log in this backup set begins at LSN 10972000000019600001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 18
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 19
The log in this backup set begins at LSN 10972000000020200001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 19
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 20
The log in this backup set begins at LSN 10972000000020600001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 20
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 21
The log in this backup set begins at LSN 10972000000023200001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 21
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 22
The log in this backup set begins at LSN 10972000000024800001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 22
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 23
The log in this backup set begins at LSN 10972000000027800001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 23
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 24
The log in this backup set begins at LSN 10972000000031100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 24
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 25
The log in this backup set begins at LSN 10972000000034900001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 25
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 26
The log in this backup set begins at LSN 10972000000035300001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 26
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 27
The log in this backup set begins at LSN 10972000000036200001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 27
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 28
The log in this backup set begins at LSN 10972000000037600001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 28
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 29
The log in this backup set begins at LSN 10973000000003200001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 29
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 30
The log in this backup set begins at LSN 10973000000034400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 30
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 31
The log in this backup set begins at LSN 10973000000046100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 31
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 32
The log in this backup set begins at LSN 10974000000008100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 32
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 33
The log in this backup set begins at LSN 10974000000016000001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 33
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 34
The log in this backup set begins at LSN 10974000000024100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 34
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 35
The log in this backup set begins at LSN 10974000000028400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 35
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 36
The log in this backup set begins at LSN 10974000000032800001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 36
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 37
The log in this backup set begins at LSN 10974000000038400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 37
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 38
The log in this backup set begins at LSN 10974000000038600001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 38
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 39
The log in this backup set begins at LSN 10974000000041200001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 39
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 40
The log in this backup set begins at LSN 10974000000041700001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 40
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 41
The log in this backup set begins at LSN 10974000000042300001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 41
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 42
The log in this backup set begins at LSN 10974000000043500001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 42
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 43
The log in this backup set begins at LSN 10974000000044400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 43
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 44
The log in this backup set begins at LSN 10974000000047100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 44
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 45
The log in this backup set begins at LSN 10974000000048000001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 45
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 46
The log in this backup set begins at LSN 10974000000051100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 46
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 47
The log in this backup set begins at LSN 10978000000570200001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 47
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 48
The log in this backup set begins at LSN 10978000000631600001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 48
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 49
The log in this backup set begins at LSN 10978000000635400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 49
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 50
The log in this backup set begins at LSN 10978000000648100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 50
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 51
The log in this backup set begins at LSN 10978000000655000001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 51
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 52
The log in this backup set begins at LSN 10978000000657400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 52
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 53
The log in this backup set begins at LSN 10978000000658900001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 53
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 54
The log in this backup set begins at LSN 10978000000659300001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 54
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 55
The log in this backup set begins at LSN 10978000000659500001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 55
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 56
The log in this backup set begins at LSN 10978000000659800001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 56
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 57
The log in this backup set begins at LSN 10978000000660300001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 57
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 58
The log in this backup set begins at LSN 10978000000660500001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 58
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 59
The log in this backup set begins at LSN 10978000000660800001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 59
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 60
The log in this backup set begins at LSN 10978000000661100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 60
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 61
The log in this backup set begins at LSN 10978000000661400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 61
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 62
The log in this backup set begins at LSN 10978000000661900001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 62
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 63
The log in this backup set begins at LSN 10978000000662100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 63
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 64
The log in this backup set begins at LSN 10978000000662600001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 64
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 65
The log in this backup set begins at LSN 10978000000662800001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 65
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 66
The log in this backup set begins at LSN 10978000000663300001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 66
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 67
The log in this backup set begins at LSN 10978000000664300001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 67
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 68
The log in this backup set begins at LSN 10978000000664500001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 68
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 69
The log in this backup set begins at LSN 10978000000665000001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 69
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 70
The log in this backup set begins at LSN 10978000000665500001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 70
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 71
The log in this backup set begins at LSN 10978000000668000001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 71
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 72
The log in this backup set begins at LSN 10978000000670700001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 72
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 73
The log in this backup set begins at LSN 10978000000674400001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 73
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 74
The log in this backup set begins at LSN 10978000000680100001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 74
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 75
The log in this backup set begins at LSN 10978000000681700001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 75
RESTORE LOG is terminating abnormally.
July 21, 2016 at 1:44 am
Just remove that second restore statement. The gui often does odd things, that's why most people advice restoring via T-SQL.
Ignore, didn't read clearly enough
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2016 at 10:55 am
Thanks for the reply. here are the results of that (removing the morning DIFF). Note that i am not posting the 30+ .trn files below for brevity but they were part of the executed statement.
USE [master]
RESTORE DATABASE [CDDB_Data_restoreTest] FROM DISK = N'{2D17E9BA-7A14-4835-9A0E-EF3DBF6FE6FE}3' WITH FILE = 1, MOVE N'CDDB_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\DATA\CDDB_Data_restoreTest.mdf', MOVE N'CDDB_Data_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\DATA\CDDB_Data_restoreTest.ldf', NORECOVERY, NOUNLOAD, STATS = 5
--RESTORE DATABASE [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\DIFF\IMUADB01$IMUA_CDDB_CDDB_Data_DIFF_20160719_060000.bak' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [CDDB_Data_restoreTest] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\CDDB_Data\LOG\IMUADB01$IMUA_CDDB_CDDB_Data_LOG_20160719_060500.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
....same error....
Msg 3201, Level 16, State 2, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL11.IMUASS\MSSQL\Backup\IMUADB01$IMUA_CDDB\{2D17E9BA-7A14-4835-9A0E-EF3DBF6FE6FE}3'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Msg 4305, Level 16, State 1, Line 4
The log in this backup set begins at LSN 10972000000010500001, which is too recent to apply to the database. An earlier log backup that includes LSN 10963000000029400001 can be restored.
Msg 3013, Level 16, State 1, Line 4
Note that the 2nd error is repeated for each of the 30+ .trn files. again, not shown above for brevity.
my understanding is that:
1. the 1st error above is because it can't find the 'virtual backup'.
2. the 2nd error is because the 'virtual backup' broke the chain and now the .trn files feel 'a bit lost'.
July 21, 2016 at 11:12 am
Not quite.
You're going to have to manually add the restore based on your full backup, rather than the virtual one, and the diff will only be useful if the virtual full was taken BEFORE your sunday night full backup. Since the server is imaged every day, that won't be the case, and the diffs are useless. You'll need the log backups all the way from the sunday night full backup in order to restore.
I strongly advise you to change the backup strategy. If you're using diffs, you can't have a random full backups happening, unless it's made with the copy_only flag. If you can't stop those backups and can't get the copy_only flag added, then you need to stop taking differentials and switch to a full + log backup strategy only.
The imaging software they're using is aware of SQL, and there should be options somewhere in its setup to ignore the SQL databases.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2016 at 11:23 am
Thanks so much. i will try that out since i have no control over making those other backups 'Copy Only'.
is there an easy way to generate a restore script to a specific point in time now that there could be a lot of Log files involved?
July 21, 2016 at 11:28 am
Try this: http://www.sqlservercentral.com/articles/Restore/95839/. Otherwise there should be restore scripts available online that check folders for the log restores.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2016 at 11:35 am
wonderful. i explore that more. thanks so much for your help.
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply