[dba-SQLServer] Attach a database without its log file

Arthur Fuller fuller.artful at gmail.com
Tue May 24 05:45:49 CDT 2011


Yup. It worked like a charm. All my old databases are now attached.

A.

On Tue, May 24, 2011 at 6:29 AM, Mark Breen <marklbreen at gmail.com> wrote:

> Hello Arthur / John
>
> And it is a great way to truncate the huge log file.  I use this trick all
> the time.
>
> just detach the db, then rename or delete the log file and then re-attach
> the db, and tell the GUI attach dialog to remove the 'missing' log file.
>  Hey presto you have a nice small log file again
>
> Mark
>
>



More information about the dba-SQLServer mailing list