Ah, perfect. This worked!


Thanks
-Robyn

-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:42 PM
To: CF-Talk
Subject: RE: SQL server question

> I recently did something really dumb - I had a really small
> SQL server database that I was using for a home project, and,
> during an upgrade fiasco (long story), I deleted it by mistake.
> Now... I see that the .MDF and .LDF files still exist in my
> MSSQL7/data folder, and I would like to restore this database,
> but I have no idea how to do it.  Any ideas?

You can use the sp_attach_db stored procedure from Query Analyzer to attach
your database and its log.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/ <http://www.figleaf.com/>
voice: (202) 797-5496
fax: (202) 797-5444

  _____  


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to