I have just been practicing some restore operations and was wondering about it when the database was taken offline and then something happened to the .mdf file and the database was not able to recover and remained offline.
I would like to get point in time recovery but get errors when I try to backup the current log file.
I am using the following to try to do it.
I receive the following error:
Server: Msg 942, Level 14, State 3, Line 1
Database 'Northwind' cannot be opened because it is offline.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
I understand that the database is offline (I put it that way) but do not understand if there is no way to recover that current log file or if it just can't when the database is offline.
Thanks for any input.
jitter
I would like to get point in time recovery but get errors when I try to backup the current log file.
I am using the following to try to do it.
Code:
BACKUP LOG northwind
TO File = 'C:\Test\northwind_current.trn'
WITH NO_TRUNCATEI receive the following error:
Server: Msg 942, Level 14, State 3, Line 1
Database 'Northwind' cannot be opened because it is offline.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
I understand that the database is offline (I put it that way) but do not understand if there is no way to recover that current log file or if it just can't when the database is offline.
Thanks for any input.
jitter
