copy production DB

• smknox

  Hall of Fame

  Points: 3275

  More actions

  August 12, 2004 at 4:37 pm

  #88382

  Hello:

  I have an easy question for this bunch. What is the best (or easiest) way to delete an obsolete DB? I have a development DB and a production DB. I would like to delete the development DB and make a copy of the production DB renamed to the dev DB's name. I would like to start with a clean copy of my production db to do some testing on the dev side.

  I detached the dev DB. So now can I just rename or delete the files and use DTS to make a new DB and use the same name as the previous dev DB?

  Thanks so much!

• David.Poole

  SSC Guru

  Points: 76034

  More actions

  August 13, 2004 at 1:28 am

  #518807

  If your production and development DBs are on the same box then simply restore the last production backup over the top of the development DB.

  If you want to delete a database explicitly then you can either use enterprise manager, highlight the database and press the delete key, or in T-SQL

  DROP DATABASE etc.

  LinkedIn Profile