the full backup will be consistent at the point it finishes.

The t-logs will give you more granular recovery points during the time it takes the full backup to run. What...

unless the gui has really changed in SQL2008 instructions on how in my original post.

all out of hours, mostly weekends. We have an 'application weekend' and an 'infrastructure weekend' but there is flexibility.

If the work involves an outage we can't even touch non-prod boxes...

disk defraggers such as diskkeeper can run with SQL up.

It would either have been due to parallelism (wait type would have been cxpacket) or latchio waits. Tends to be prevalent on heavy IO processes (such as reindexes)

Its not a...

If SQL cannot start databases SSMS will show the databases without a plus sign next to them, EM shows them as suspect.

please,please post the info Gail has asked for.

mattfitz (2/18/2010)

---

Looks like the business has agreed to a weekly data load. It appears i'll have to copy a compressed full backup file across a relatively slow WAN connection and...

Paul White (2/18/2010)

---

Yes George, I...

yes,...

might affect whether simple backup\restore is viable and the initiation of log shipping.

with that size of database logshipping with restores held off during the day might be your best bet, certainly in terms of simplicity. I would want backup compression available though,...

SQL Server MVP Deep dives - some of the purchase price goes to charity as well.

thats because dbcc timewarp has exacted revenge 🙂

I don't have logshipping on SQL2008 but presuming it has not changed from 2005 its set on the restore transaction log tab under 'secondary server instances and databases' in the...

Robert Davis (2/18/2010)

---

The problem with this scenario isn't the load that the mirrors put on the server. The problem is what happens if you have to fail over all databases...