September 27, 2007 at 3:16 am
My sql server database has suddenly crashed.i don't have any backup except a .mdf file.
while i was trying to restore my database from mdf file with sp_attach_single_file_db i got an error
File activation failure. The physical file name "D:\Program Files\Microsoft SQL Server\MSSQL\Data\Mttransuite_log.LDF" may be incorrect.
The log cannot be rebuilt because the database was not cleanly shut down.
can anybody help me in this regard
September 27, 2007 at 9:54 am
Is your database attached still or not?
If so, you'll need to build a new transaction log. See my advice in previous thread I replied to.
If not, you'll need to use the hack method of attaching a corrupt database by creating a dummy database, swapping out the files, and then building a new transaction log. Product Support can help you with all of this.
Also - you should get yourself a backup strategy so you don't have this problem again.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply