Copy database question

• nate crawford

  Newbie

  Points: 1

  More actions

  November 17, 2004 at 10:53 am

  #109515

  Hi guys.

  I'm an Oracle DBA trying to copy a sql server database.

  All I need to do is copy an existing database to the same server and obviously rename it.  (it's going to be a new test database)

  I looked at the "restore as" option in the restore wizard, but I had a panic attack because I didn't want to screw up the original database. (and I can't shut it down)

  What is the best way to take a copy of one database and drop it onto the same server with a different name.  Is it possible to do so without impacting users on the original database?

  Thanks for any input!

• Osoba

  SSCommitted

  Points: 1964

  More actions

  November 17, 2004 at 11:05 am

  #530525

  I would do the following if you're doing this on the same server.  The database copy wizard doesn't allow database renaming within the procedure:

   

  1)  Backup your DB_original

  2)  Create DB_copy

  3)  Choose to "Restore Database" (Right click Db_copy)

  4)  Under "Parameters" show backups of database:  Choose DB_original.

  5)  Select the backup file desired.

  6)  Go to the "Options" tab and select: "Force restore over exisitng database"

  7)  Execute restoration

  8)  Check for valid restoration and then back up your new db.