Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Problem with that is - if either SQLPROD2 or SQLDR2 is offline - the SP fails, because referential integrity is validated at "prepare", and an inaccessible server throws an error, even though it would not be actually referenced at all at execution.
IF @@SERVERNAME = 'SQLPROD1' EXEC SQLPROD2.MyDB.dbo.mySP ELSE EXEC SQLDR2.MyDB.dbo.mySP
|Create SQL Server Job to perform backups of all the databases in a server instance||17||38|
|SQL Backup Question||2||29|
|HTML <font style="color:red">||9||29|
|Requesting help with creating an SQL query to select similar records||4||11|