SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: Need SQL Help
-
Jan 25, 2002, 20:04 #1
- Join Date
- Feb 2000
- Posts
- 53
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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.
-
Jan 26, 2002, 06:48 #2
- Join Date
- Jan 2001
- Location
- Alkmaar, Netherlands
- Posts
- 710
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Hello,
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.
Good luck
Bookmarks