Results 1 to 5 of 5

Thread: Restoring

  1. #1
    Join Date
    Mar 2003
    Posts
    5

    Question Restoring

    Hi All,

    I'm trying to restore a database to a completely new database from an exsiting full backup.

    On the backup device there are two full backups from different dates.

    How can I specify which one of the two backups I want use for my restore (The only difference is the date ??

    Thanks,

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    when you rin this command you can find what position the filegroup is .


    restore headeronly from disk = 'd:\mssql70\backup\xxx'

    then run restore command by passinf FILE=filenumber parameter.

    restore database xxx123 from disk = 'd:\mssql70\backup\xxx' with FILE=6 ,
    move 'northwind' to 'd:\xxx123.mdf',
    move 'northwind_log' to 'd:\xxx123.ldf'

  3. #3
    Join Date
    Mar 2003
    Posts
    5

    Smile Question

    Thanks for the reply MAK.

    Just a quick question on the restore process.

    1. Why is it neccessary to move the data and log files. Won't these be created new ?

    2. Will moving these affect the original database from which the backup was based on ?

    Thanks again,

    hillchaser

    Melbourne/Aust/12:38 pm

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    if you are restoring the same database then no need to move. but if you are restoring the backup as a new database then you need to specify different databasename and mdf and ldf location.

    here i am restoring Northwind database as xxx123 database. so i have to specify new .mdf and .ldf names and location.

  5. #5
    Join Date
    Mar 2003
    Posts
    5

    Thanks MAk !

    Thanks mak.

    Will use.

Posting Permissions

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