How do you recreate a database on a new installation of SQL Server 7 with only the original MDF and log file? The original installation of SQL Server that contained the database is now gone. I have tried various wizards and statements, but can't find anything that seems to be on point. Any help would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Starting over with an MDF file
- Thread starter tanuki3
- Start date
Set up a new database on the server. Make sure that the .mdf and .ldf files have the same name and are the same size as your previous version of the database. After you have this database set up, stop the server and replace your new .mdf and .ldf files with the original files. Now go to the SQL Server Enterprise Manager and the database should be working ok. I hope this helps. I haven't tried it with Ver7.0 but it works with Versions 6.5 and 2000.
- Status
Similar threads
- Question
- Locked
- Question