database
newsgroups
Home
All Groups
Group
Topic
Archive
Search
About
attach db with a deleted log
microsoft.public.sqlserver.programming
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?
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
--
Other interesting topics
Getting an unused number from a set of numbers?
Design: multiple columns for primary key
Whats Wrong with the Query?
TSQL Debugger Oddity
Newbie:UNION with SELECT TOP
related:
Server news
Exchange news
Outlook news
Developer programming
IT programming
Web programming
Tech programming