The result format is hrs:mins:secs:millisecs

So based on that, 16hrs:16mins...

Thanks Perry!

Now how does that tie into the data extents?

Also how about the previous inquiry into log backup operations?

Trust me Gail!

I have followed you and Perry for a while and your expertise is in no way in question here. Just trying to get deeper with the subject as...

Yes Gail!

Thanks for the insights.

It just gets a little confusing sometimes.

There is documentation about differentials relying on the data extents as well as the LSN so which is it exactly?

Also,...

http://technet.microsoft.com/en-us/library/ms345448(v=sql.105).aspx

Thanks Gail.

Hope this helps;

Run this script to show you how long it will take to become online again for versions 2005 - 2008R2

DECLARE @DBName VARCHAR(64) = 'databasename' -- Change this...

My point exactly. If the diffs don't rely on LSN, how then can they be applied to the full and how do they know what full they are built on?

The...

That was a typo. LSN not LAN. typed from my phone.

I do believe that diff and log backups don't break the log chain but the rely on the LAN from the last full to work don't they? If not, why...

Very True Mike;

The undocumented option will be to use

BACKUP LOG MyDb TO DISK=’NUL:’

Just like TRUNCATE_ONLY, this solution has a ton of drawbacks and compromises your recoverability. This should only...

Consider Using Ola Hallgrens backup solution to handle full and Tlog backups in your environment. It works great. a 32GB log file can not only fill up your drive and...

The only other viable option is see here would be geo clustering or having a cname alias in AD for the instance and using that in the application connection string....

You have a great idea here. Clustering gives you HA for the instance (memory structure, internal storage engine and background processes) but maintains a single point of data. As far...

Consider the below as a possible solution;

USE master

exec sp_changedistributor_property

@property = N’heartbeat_interval’,

@value = 5;

GO;

Also, the below article may help better explain and understand your issue...

http://maginaumova.com/the-replication-agent-has-not-logged-a-progress-message-in-10-minutes/

GOODLUCK

To add insult to injury, vCenter backups will be controlled by your server or VM experts and that takes control of the backups away from the DBAs and created a...