April 4, 2008 at 1:10 am
Hi
Transaction log file has been deleted from the database., how recover it or how to add?
Thank you
koteswarrao
April 4, 2008 at 1:21 am
If you have a backup (including log backups) restore the database and logs. Otherwise:
Start up SQL Server. The database will not recover correctly. Then detach the database, and reattach it, supplying only the name of the data file(s). SQL Server will not be able to activate the log file so it will automatically create a new one.
April 4, 2008 at 1:38 am
Dear karl
Thank you for your reply........by re runnuning the sql services one log file will be created automatically is it.But while stop the services we cann't make any transaction is it..
Thank you
April 4, 2008 at 1:42 am
y.koteswarrao (4/4/2008)
Dear karlThank you for your reply........by re runnuning the sql services one log file will be created automatically is it.But while stop the services we cann't make any transaction is it..
Thank you
You need to start the SQL Server service in order to detach and re-attach the database.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply