GilaMonster (1/11/2012)
Perry Whittle (1/11/2012)
To re attach a database with a missing log file just use either
sp_attach_single_file_db
CREATE DATABASE .... FOR ATTACH_REBUILD_LOGWhich only works if the database was shut down cleanly before the log was deleted, not in all cases.
But it's logically the first place to start, why go to all the effort of hacking the file in if a simple attach may suffice.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉