Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Texas
    Posts
    2

    Unanswered: Copy DB for testing purposes

    I have a DB I want to make a copy of for testing purposes so we don't crash our production DB. I want the new "Test" DB to reside in the same SQL Server Group on the same SQL server. I have tried the Copy DB wizard but it will not allow you to copy the DB to the same server. What is the best way to do this?

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Take a backup of the prod db ... restore as a different db name ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Mar 2004
    Location
    Texas
    Posts
    2
    I'll give it a try..


    Thanks,
    rbrady

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to books online for BACKUP/RESTORE topic on more information.
    But its better to restore the database on different rather on the same machine which may have issues with the testing.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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