October 20, 2020 at 7:15 pm
Hi all
I am pretty new with SQL Server and I have some doubt about doing DR tests with SQL Server.
I have around 25 database running in SQL Server 2012 Standard Edition with Log Shipping setup in another Data Center. I have to do a simulation DR test, breaks Data Center communication, open the secondary database as primary for one day so the application team use the Data Center as the real primary Data Center and day 2 restore to previous situation. back as DR site.
Once I open the databases and application team starts to insert, deleting data etc. Until now the previous SQL Server DBA had to recreate all log shipping from scratch. Very time consuming (there are a couple of dabase which are 1TB). I wonder if we can do this to minimize the time to restore the Data Center to previos role.
Is this doable?
Thank you in advance
October 21, 2020 at 4:03 pm
If your database is in standby mode, you can do a snapshot, but you cannot set a standby database online if there is a snapshot on it.
You can do a snapshot on the online database.
Do you have a lot of disk space?
Sounds like you want to discard changes after test and go back to synchronizing mode with primary? In that case restore the db from full, latest differential and subsequent xlog
October 21, 2020 at 10:07 pm
Hi
I want to simulate the DR test with secondary database (log shipping targets).
But I am talking about Storage Snapshots, not database snapshots.... It seems to me you are talking about database snapshots?
I have done the same DR tests with similar steps I described above with Oracle Databases with success but wonder if same would work with SQL Server.
Cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply