September 10, 2012 at 7:28 am
Actually i have taken the Database offline and have accidently deleted the log file. When i'm trying to get back the database online, i'm getting error 945 "could n't find the log file.
When i diconnect and reconnect the Sql Server instance, the offline database is missing.
Can any one please hellp me to get back the database.
September 10, 2012 at 8:38 am
gpm.alwyn (9/10/2012)
Actually i have taken the Database offline and have accidently deleted the log file. When i'm trying to get back the database online, i'm getting error 945 "could n't find the log file.When i diconnect and reconnect the Sql Server instance, the offline database is missing.
Can any one please hellp me to get back the database.
Can you recover the log file? The error message shouldn't be too surprising since you deleted the log file. :w00t:
Do you have a backup you can restore from? You did take a backup right before you took it offline right???
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 10, 2012 at 9:17 am
I have restored the database successfully without the log file
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply