SSMS Copy Database utiliy - how solid is it & can you rely on it?

  • Hi

     

    If I want to make a 100% accurate copy of a database with nothing missed, triggers, sprocs, indexes, data  etc etc copied

    will SSMS Copy Database do this reliably?

    i.e. Right click on DB, Tasks, Copy Database....

    There are reasons we cant use back up & restore.

  • what are the reasons for not using backup/restore?

    but the copy database option, using SMO, will copy all db objects - data will be the same with likely exception of timestamp/rowversion columns

  • If this is a regular requirement - you may want to consider upgrading to SQL Server 2016 (or higher) where you have the new option of using DBCC CLONEDATABASE.

    But - it really depends on why you need to do this and why backup/restore is not an option, and how often it needs to be done.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply