Post reply

Problem in Restoring Database with different Name

  • March 18, 2007 at 10:16 pm

    #119192

    If I restore a data of one Database 'A' to another Database 'B'. in doing so my Database 'A' doesnot work.

     

    This work properly in Sybase. is it possible in Sql Server 7.0

  • March 19, 2007 at 1:52 am

    #695642

    hi

    how are u trying the restore? i did not get this "If I restore a data of one Database 'A' to another Database 'B'".

    Are u using Restore the backup of a database or just moving the data from one db to another?

    "Keep Trying"

  • March 19, 2007 at 9:30 am

    #695747

    I assume databases 'A' and 'B' are in the same instance.  Can you post the RESTORE command you used?  You should use WITH MOVE to create new database files for the new database.  See "Restoring databases with a new name" in BookOnLine.

    Greg

    Greg

  • March 19, 2007 at 10:01 pm

    #695838

    Thanks Greg ! Actually I was trying to Restore data of one database to another database and this I 've accomplished using Move Command .

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply