Results 1 to 2 of 2

Thread: Datbase Restore

  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: Datbase Restore

    Hi All,

    My client has sent me one database. It is a one file with name Eyeab10072003. He is saying just restore this database on the 2000 server. How shall i procede with this. what would be the restore command. I want to restore it with diffrent name

    Vini

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    THis is a script to restore a backup from disk to a new database and then rename the file and log names

    RESTORE DATABASE TestDB
    FROM DISK = 'c:\nwind.bak'
    WITH MOVE 'northwind' TO 'c:\test\testdb.mdf',
    MOVE 'northwind_log' TO 'c:\test\testdb.ldf'

    alter database testdb
    MODIFY FILE (NAME = 'northwind', NEWNAME = 'testDB')

    alter database testdb
    MODIFY FILE
    (NAME = 'northwind_log', NEWNAME = 'testDB_log')


    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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