Post reply

creating a Copy of database for testing

  • September 2, 2004 at 9:13 am

    #83645

    Hi,

    I have a server running an instance of SQL Server 7.0 with a production database. There are some small changes in the application that uses this database. I need to create a copy of the database (with a different name) so that I can test the changes before deploying on a new machine.

    Any ideas?

    Regards

    Sridhar

  • September 2, 2004 at 9:43 am

    #521536

    I often restore the database to the same server under a new name. 

  • September 3, 2004 at 12:53 am

    #521586

    Hie

    For this i usually use enterprise manager.First detach your database, copy the mdf and ldf files for the db and put them in a seperate location from the current db's location.

    then using enterprise manager again, select attach db when you right click

    (local server) --> databases --> All Tasks.

    on the dialog box that come up where it says Attach As, put the test db name that you want to use.

    that should do the trick

    Everything you can imagine is real.

  • September 3, 2004 at 10:19 am

    #521686

    Both options work very well...but the second option of coping the files and attaching a new database will be faster than a restore. 

     

    Have fun

    Eric

  • September 6, 2004 at 1:32 am

    #521814

    Agreed...for SQL 7 and 2000, the second way is better and faster. What about 6.5, any idea?? Haaha...

     

    Kindest Regards,

    eiddie dredd

    No Pain No Gain

  • September 6, 2004 at 2:26 am

    #521826

    Faster being one aspect. But I usually prefer the backup restore process as it is clean and less error prone. Not that the copy paste doesnt work. Just my comfort level .

    Vinod Kumar

    http://www.ExtremeExperts.com

Viewing 6 posts - 1 through 5 (of 5 total)

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