November 3, 2020 at 9:54 am
Hi
I'm looking into recovery plan for individual SQL databases.
The scenario I'm planning for, is if a single SQL database on an instance with multiple databases, for multiple applications, becomes unavailable.
My thought is to have a cold standby server we can restore the database to, then use CLIconfig on the application servers to point to the restored database. This will allow us to troubleshoot and monitor the databases in question without impacting the other databases on the original SQL Server. I'm slightly concerned that using CLIconfig might impact the other applications using the original SQL server, but can't think why it would. I think it might just be generalised DBA paranoia!
Has anyone tried something similar? I realise this solution only works if the database is only ever accessed by the application servers. Also I realise Availability Groups are another option, but for various reasons I want an alternative to them available as well.
November 4, 2020 at 10:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply