SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Need SQL Help

Hybrid View

  1. #1
    SitePoint Enthusiast
    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.

  2. #2
    SitePoint Guru
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •