Need SQL Help
I have a copy of a sql server 7.0 database the actuall file *.mdf. What I need to know is how I take that .mdf file and "restore" it so I can start using the database. I need to get this back up asap. A co worker of mine is depending on this. They messed up and do not have the standard back up files.
You need one more file I think it is .ldf (if I dont remember wrong) you can copy to the data directory of the SQL Server.
Then in enterprise manager, in tools there should be option called restore. Then it is straight forward.