Home Forums SQL Server 2012 SQL 2012 - General When do you use CREATE DATABASE ... WITH FOR ATTACH_REBUILD_LOG? RE: When do you use CREATE DATABASE ... WITH FOR ATTACH_REBUILD_LOG?

  • January 28, 2015 at 9:22 am

    #1773732

    Emil Bialobrzeski (1/28/2015)

    I've used it actuallt 2 months ago when i occured a log file corruption, long story short, this caused the database to go in suspect state, the database was in simple recovery model, i was only a bit worried that there are some transactions not checked in, but if so i wouldnt be able to use this option. Luckly i was able to take the mdf file reattach it with new log and everything seemed to be working.

    Was using this your first response or did you do other things before using it? (I'd like to know details if you care to share.)

    How much data did you lose in the end?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.