Post reply

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

  • June 4, 2020 at 7:33 am

    #3760332

    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

  • June 4, 2020 at 6:01 pm

    #3760599

    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 2 posts - 1 through 3 (of 3 total)

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