September 27, 2007 at 5:43 am
i have taken backup of my database 15 days back.suddenly my database has crashed.i have only .mdf file and the backup i have taken 15 days back.
how to create .ldf file or how restore my database to the latest point of time
please help in this regard.
thank you
September 27, 2007 at 9:51 am
If you've lost the .ldf file and all you have is a backup from 15 days ago, you have two options:
1) restore the 15-day old backup and lose the last 15 days of work
2) call Product Support to help you build a new transaction log. You may need to run CHECKDB with REPAIR_ALLOW_DATA_LOSS if there were any active transactions at the time you lost your transaction log, as the database may be transactionally and structurally inconsistent. See http://www.sqlskills.com/blogs/paul/PermaLink,guid,cd67ae90-9499-4ede-8ce5-54e922bbe556.aspx for more info.
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