NeonRant
2/14/2020 - 4:00 AM

Restoring a Database as a Clone of another DB on the same server

Seems easy right? So why when I tied to clone a DB by restoring it to the same server as the DB I had taken the backup from, it corrupts bth the original DB itook the bacup from and the new one, leavingboth offline. Yikes!! It's all to do with the Tail-Log backup. Do't do it!!

notes.md
content_copyfile_download
  • Rendered
  • Source

Restoring a Database as a clone of an existing DB

Steps

After selecting the DB to restore, you must change the name to the name that you would like the new DB to be named.

Once renamed, switch to the files tab and ensure that the files are pointn to the names ar pointing to the new DB name.

Then go to the Options tab. (Below)

Make sure that the follwing are set:

  • Overwrite the existing Database - Check
  • Take tail Log Backup - Uncheck
  • Close Existing connections to the database - Check

This should ensure that both DB's remain on lin anddo not affecte each other.