Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Posts
    37

    Unanswered: Creating a test environment

    I just got my first job doing some DBA work (junior level) in a small company using SQL Server 2000.

    I would like to make a copy of the production DB and use it for development of SP's, DTS packages and views.

    What is the safest way for me to copy the entire production DB, to a new DB on the same server?

    Should I create a new DB, and do a restore of the production backup?

    Any help would be appreciated,
    Thank you.

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    restoring from a backup is probably the most common way.

  3. #3
    Join Date
    Nov 2002
    Posts
    37
    Quote Originally Posted by jezemine
    restoring from a backup is probably the most common way.
    Should I restore to a 'new database' I create, or restore and just supply the name of 'development', for example...

    Thanks for the reply

  4. #4
    Join Date
    Feb 2007
    Posts
    71
    Quote Originally Posted by HomersDonut
    Should I restore to a 'new database' I create, or restore and just supply the name of 'development', for example...

    Thanks for the reply
    you can try restoring the backup via Query Analyzer. Try consulting BOL for the syntax. Based on my experience it creates the database along with the devices. You can also specify that it move it's devices to a specific path.

Posting Permissions

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