Hello Edward,

In the stored procedures you have used as an example you have two queries. One to retrieve all the records and one to retrieve a single record....

How long is your backup retention time? If your backup retention time is expired than it's no longer an issue. So it's only temporary a problem. How long do you...

I could think of one way, but I wouldn't recommend it. Create snapshot of your database immediately after your full backup. Look at the file size using compact.exe. For example:

compact.exe...

Just checking. Is your cluster set up correctly? Is SQL Server installed in cluster mode or SQL Server installed normally? Is SQL Server added to the second node?

Is MSDTC set...

You can avoid using sp_change_users_login by transferring the logins one time using sp_help_revlogin (see https://support.microsoft.com/en-us/kb/918992)

You can also use the Use the Copy Database Wizard to copy the databases...

Dougieson (12/18/2015)

Perry Whittle (12/16/2015)

This has been possible since sql server...

MSDN subscriptions are for non-production only, unless otherwise specified e.g. 1 production Office license and 1 production Visual Studio license per licensed MSDN user. Another restriction that sometimes is mentioned...

AlwaysOn Availability Groups is a technology based on databases mirroring. The following is appropriate for both. It helps if you are familiar with setting up log shipping.

First step is...

Something all databases on a given instance share is the buffer cache (and other memory pools). SQL Server decides on its own which database pages are kept in memory. You...