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?

  • 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.