Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151

    Unanswered: Restoring database question plz help!

    Here is the question if i reinstall sql server 2000 ent can i use my full back up file to reproduce all of my prior existing database and do i need the data file like the .ldf, .mdf, .ndf to do this and if so i do i do this without the data files

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Your backup file should be all you need to restore your database to the moment that it was backed up. You will need to restore log files to recover any changes since the backup was made.
    You should test your backup/restore plan first to make sure it works and you know how to do it before you wipe out your current installation!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    OK thanx but i cant test this because my sql server service doesnt want to start and i have admin rights. it givin me a unexpected error is the best thing here to reinstall sql server and then restore the back up file.

  4. #4
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    basically rebuild the ole thing again.

Posting Permissions

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