November 30, 2020 at 8:16 pm
Hi all,
I have a database that resides on server A and I need to create its clone on server B. I am using DBCC clonedatabase command. I have a linked server from B to A. And I can create an opposite linked server too, from A to B.
Is it possible, and if yes, how?
Thanks
November 30, 2020 at 9:50 pm
I'm not sure that will work. The CloseDatabase command takes source_database_name and target_database_name as parameters, so it creates a read-only copy on the same server.
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2020 at 7:11 am
DBCC CLONEDATABASE is not multi server, it copies it to the same server so won’t meet your requirements.
Automate a backup restore operation using the traditional backup routines or use bacpac etc to do it or powershell.
I would strongly recommend getting the DBATools powershell module for this and using the cmdlets in that, DBATools makes life so much easier these days.
December 1, 2020 at 6:40 pm
What is the purpose of this secondary copy of the database? There are several options available - depending on what you intend to do with that copy.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
December 1, 2020 at 11:16 pm
If both databases live on the same SAN, checkout the documentation for the SAN... it may have the ability to do a "SAN Snapshot", which is incredibly fast and doesn't have to live on the same server... just the same SAN.
--Jeff Moden
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply