> 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/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

