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]
- RE: SQL Server Question Dave Watts
- SQL server question Steven Dworman
- RE: SQL server question John Wilker
- Re: SQL server question Jon Hall
- SQL Server Question Tangorre, Michael T.
- RE: SQL Server Question Won Lee
- RE: SQL Server Question Tangorre, Michael T.
- RE: SQL Server Question Greg Luce
- RE: SQL Server Question Won Lee
- RE: SQL server question Dave Watts
- SQL server question Robyn Follen
- SQL server question Tim Laureska
- RE: SQL server question Michael T. Tangorre
- RE: SQL server question Tim Laureska
- RE: SQL server question Michael T. Tangorre
- RE: SQL server question Tim Laureska
- RE: SQL server question Taco Fleur
- RE: SQL server question Tim Laureska
- RE: SQL server question Tim Laureska