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

    Unanswered: Restoring database question plz help!.

    yesterday my sql server 2000 ent crash because of an operating system problem i seem to have lost all my .ndf, .ldf, .mdf files from the DATA folder but i still have my full backup files in the BACKUP default folder from the day earlyer can i still restore my database to the state prior with all my data in it.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You can restore the database back to the time of the completion of the last backup. If you do only complete database backups, you can restore to the end of the last backup. If you do incremental backups, you can restore the last complete backup plus all of the incrementals in an unbroken chain. If you have any missing incrementals, the ability to restore them stops with the first one you are missing.

    -PatP

  3. #3
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    so your saying that i can recover lets say all my databases under that server as long as i have the full back up file for those databse i dont need the datafiles ?

  4. #4
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    basically the .BAK file as all the information. what does the master database containt ?

  5. #5
    Join Date
    Apr 2004
    Posts
    101
    have a look at this topic on Books online..
    "Restoring the master Database from a Current Backup"
    Once you are done with Master you can restore user dbs with old .BAK files.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The master database contains "system" things like logins/passwords, linked servers, etc.

    The msdb database contains things like SQL Agent jobs, DTS packages, etc.

    These things are important, but are rarely "life or death" issues.

    -PatP

Posting Permissions

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