June 1, 2011 at 5:21 pm
I have a full backup and 3 differential backups after that, i did restore full backup successfully with "no recovery" and restoring a latest(3rd) differential backup on top of that, its been running for a while without completion and i found 2 messages in the log saying
error 1 - Error: 50000, Severity: 18, State: 1.
error 2 - SQL LiteSpeed: The process cannot access the file because it is being used by another process.
LiteSpeed could not open the Backup file: (\\OBBEAVER\Daily\SIRS3.bak). The previous system message is the reason for the failure.
These errors does not make any sense to me becasue i could restore the full backup from the same file location but when applying the differentail backup, i get this message after 3 hours of execution.
Any help would be appreciated.
If i fail to restore differential for any reason how can i make the datasbe usable as i have restored full backup with "no recovery"
Also i would like to know if i can restore multiple differential backups on a full backup?
June 1, 2011 at 6:15 pm
Tara-1044200 (6/1/2011)
I have a full backup and 3 differential backups after that, i did restore full backup successfully with "no recovery" and restoring a latest(3rd) differential backup on top of that, its been running for a while without completion and i found 2 messages in the log sayingerror 1 - Error: 50000, Severity: 18, State: 1.
error 2 - SQL LiteSpeed: The process cannot access the file because it is being used by another process.
LiteSpeed could not open the Backup file: (\\OBBEAVER\SIRS3.bak). The previous system message is the reason for the failure.
These errors does not make any sense to me becasue i could restore the full backup from the same file location but when applying the differentail backup, i get this message after 3 hours of execution.
Any help would be appreciated.
If i fail to restore differential for any reason how can i make the datasbe usable as i have restored full backup with "no recovery"
Also i would like to know if i can restore multiple differential backups on a full backup?
I don't know LightSpeed, so someone else would have to answer that. I do know that \\OBBEAVER\SIRS3.bak is not valid. I'm assuming OBBEAVER is a computer name of a computer elsewhere on your network. But a SHARE NAME is missing. Should be named something like \\OBBEAVER\C$\SIRS3.bak or \\OBBEAVER\MyShare\SIRS3.bak. Something like this. I would expect a failure right away if this were the real problem though.
As for the differential question: You can bring the database back online with RESTORE DATABASE [MyDBName] WITH RECOVERY. A differential backup contains all data changed since the last full backup. http://msdn.microsoft.com/en-us/library/aa174458%28v=sql.80%29.aspx. Therefore, if the most recent diff backup fails to restore, you can try to diff previous to that (but you will not be restoring all data). Also, don't forget to restore your tlog backups if you eventually get your most recent diff backup restored. Do not restore all diff backups; only the most recent diff backup (since a diff backup contains only changes since the last full backup, not since the last diff backup).
Edit: To make the link an actual link rather than text.
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
June 1, 2011 at 6:57 pm
the link is not the problem because i might missed while writing in the forum. now its corrected.
June 2, 2011 at 3:15 am
Try copy the file locally and then restore
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply