Viewing 6 posts - 1 through 7 (of 7 total)
You method worked perfectly and we were able to restore all data. Now I just need to create a better backup plan.
Thanks!
September 26, 2017 at 4:19 pm
Yikes, missed that. Now my database is in Suspect status. I tried to bring it online with no success. I get the same error as I got before I truncated...
September 25, 2017 at 9:02 am
Thanks again. I am trying to backup the tail end of the log file using the following:
BACKUP LOG [database_name] TO DISK = N'C:\Temp\database_name_log.bck'; WITH INIT, NO_TRUNCATE;
GO
September 24, 2017 at 3:18 pm
Thanks again. Last question before I proceed. When you say hack attach the database, you mean the following, correct?
- Make a backup of restored database that is missing data...
September 24, 2017 at 7:43 am
Thanks for the detail. There are no log backups from the database. The only log file I have is the LDF from right before the system crashed. Would this process...
September 24, 2017 at 6:55 am
Viewing 6 posts - 1 through 7 (of 7 total)