Home All Groups Group Topic Archive Search About

attach db with a deleted log

Author
2 Dec 2005 12:31 PM
Jason
Hello,

How can i attach a db where there is a log deleted.

When i want to attach the db, i cannot click the ok button because a
second log-file is missing.

Anyway to work around this?

Author
2 Dec 2005 12:45 PM
David Portas
Don't use Enterprise Manager. Use sp_attach_db or
sp_attach_single_file_db. See Books Online for details and examples of
those commands.

Make sure you have a good backup of your MDF/LDF files before you try
to attach them.

--
David Portas
SQL Server MVP
--

AddThis Social Bookmark Button