December 21, 2011 at 5:06 am
Using the Maintenance plan tool I have created a full backup job and a transaction backup job which are part of the same plan but run on different schedules. they are both executed by the sql agent account and run without error.
when testing if i restore the bak file to a new database it will restore without any problems, if i try to do a point in time restore it fails with
Message
BackupTapeFile::OpenMedia: Backup device '{DB9F9079-44E6-4827-A463-820D71E5E826}5' failed to open. Operating system error 2(failed to retrieve text for this error. Reason: 15105).
when looking at the jobs the main backup and first transaction log is executed by nt authority\system and the rest by the domain\sqldba account.
anyone know why ? the agent jobs are both run by the agent account (domain\sqldba) according to their properties
December 21, 2011 at 5:21 am
December 21, 2011 at 6:27 am
Using the management console it scripts out as
RESTORE DATABASE [camilive_error] FROM TAPE = N'{D6F0FF6E-A3A4-4231-8D72-BA05A76525C5}3' WITH FILE = 1, MOVE N'my_database' TO N'D:\Data\my_database_error.mdf', MOVE N'my_database_log' TO N'D:\Logs\my_database_error_1.ldf', NORECOVERY, NOUNLOAD, REPLACE, STATS = 10
GO
RESTORE LOG [camilive_error] FROM DISK = N'NUL' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10
GO
RESTORE LOG [camilive_error] FROM DISK = N'F:\Back ups\my_database_2011_12_20_070006_5633188.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10
GO
RESTORE LOG [camilive_error] FROM DISK = N'F:\Back ups\my_database_2011_12_20_080001_0255596.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10
GO
RESTORE LOG [camilive_error] FROM DISK = N'F:\Back ups\my_database_2011_12_20_090005_9227714.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10
GO
RESTORE LOG [camilive_error] FROM DISK = N'F:\Back ups\my_database_2011_12_20_100008_0679244.trn' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10
GO
RESTORE LOG [camilive_error] FROM DISK = N'F:\Back ups\my_database_2011_12_20_110010_0842520.trn' WITH FILE = 1, NOUNLOAD, STATS = 10
GO
December 21, 2011 at 7:03 am
are you craeting you restore script from backuphistory tables from msdb. I am doubting below statement causing you the error. the 'NUL' is windows directory ,virtual decice which is treated as file. anything which written on 'nul' is discarded by OS. it might be like someone has taken the log backup on nul device. which caused log chain break. so your log backup file is missing for that perticular file. try with excluding this statement from restore script.
RESTORE LOG [camilive_error] FROM DISK = N'NUL' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10
For more details about Device='nul' check below post.
http://www.sqlservercentral.com/Forums/Topic958673-357-1.aspx
December 21, 2011 at 9:21 am
If that line is omitted there would be a break in the LSN sequence nmbers and it wouldnt be able to run.
that particular transaction log backup is not in the daily schedule which is 7 am till 9 pm, it occurs at 00:01 and i dont know why because its not in any scheduled job
January 19, 2012 at 5:03 am
For anyone using Virtual Servers and VEEAM VSS backups it seems to be responsible for my and other peoples problems, see link below
http://forums.veeam.com/viewtopic.php?f=2&t=2533&sid=ecd2b6ca9d2294af0b49649401e4d234
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply