Attach database without log file in SQL 2005
Posted on 2007-10-05
We are running MOM and having problems with the database. The log file reached 86GB and filled up the whole of the D Drive it was living on.
I wanted to take a backup of the database but it kept failing, i eventually found out that this was because the external HD i was trying to backup too was FAT 32 and kept crashing at about 4GB (no alarm bells went off in my head....)
However I was able to detach and attach the database until i tried something.
I added an extra log file to the database and tried the shrink log file within Management Studio to empty the original log file and hope it would fill up the log new log file. However this didn't do anything and i detached the database again and tried copying the files onto the external drive. Again as it was fat 32 could not take the large files so formatted as NTFS and deleted the extra log file i created. I have a copy of the mdf and original ldf safe on my external disk now as well as the orignal files on the server.
When i try to attach the database it is asking for the extra log file i created. And have tried to attach the database with removing the extra log file but it still wont attach and load the database.
I was going to use sp_attach_single_file_db but it mentions to not use it on a multi logged database.
Is there anyway i can attach this database?
For the record i have no full backup of the database!
Any help is muchly appreciated!