DECLARE @XML XML;

SET @XML = '<?xml version=''1.0'' encoding=''UTF-8'' standalone=''yes'' ?>
<!--File Created By SMS Backup & Restore v8.20.27 on 03/06/2017 17:19:03-->
<?xml-stylesheet type="text/xsl" href="sms.xsl"?>
<smses count="3"...

Microsoft are aware and bug closed - "as by design" https://connect.microsoft.com/SQLServer/feedback/details/778069/default-datafile-settings-not-applied

https://www.mssqltips.com/sqlservertip/3076/how-to-read-the-sql-server-database-transaction-log/[/url]

Have you checked network in between both servers? Are they on the same SAN? Anything obvious in SQL error logs?

Just create a powershell script to connect to your DB and schedule it to run every X seconds and email you if it fails.

Good article by Brent Ozar that might be of some use to you.

Here[/url]

Same datatypes on columns?

You could create a view?

https://msdn.microsoft.com/en-GB/library/ms187956.aspx

You can try some of the 3rd party tools that allow you to attach database backups and work with them as with live databases. You can try SQL Virtual Restore...

Could you create a trigger to capture deletes and insert to your audit table?

Same data, same hardware?

Not in SQL server - this guy needs to speak to his host to see if there is any connection limit to his "app pool"/server

Modify this powershell script to loop through an array of servers and then db list.

$SQLAdminUser = 'AdminUser'

$SQLAdminPwd = get-content "PathToSecuredCredentials.txt" | convertto-securestring

$srvConn = New-Object('Microsoft.SqlServer.Management.Common.ServerConnection') ('ServerName', $SQLAdminUser, $SQLAdminPwd)

$srv = New-Object...

Did you duplicate your installation if so generate a new SID.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/dfd21c3f-f8c9-469f-a5d0-c7bb34fa99a2/ssrs-2008-r2-http-error-503-the-services-is-unavailable-after-server-rename?forum=sqlreportingservices