June 4, 2020 at 7:11 am
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.
June 4, 2020 at 7:33 am
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
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