You can use a strategy calling sliding window to make import and archiving faster and much easier to automate.

You can read about it here.

http://technet.microsoft.com/en-us/library/aa964122(SQL.90).aspx

That doesn't make sense.

100 GB is not too high especially depending on load and size of the database.

Just because it might be too much for the servers in your company...

I am currently setting up a clustered mirrored server on a offsite collocation for DR.

The problem with having automatic failover for mirroring is that if the principal clustered server fails...

The problem happens when a query uses allocation scans to scan number of pages in a row, and while it is scanning another process updates or inserts records causing page...

Craig Farrell (5/2/2011)

---

You're correct, it's valid, but pointless. SQL doesn't stop you from doing it, but it has no effect.

Basically you're saying make sure my ID exists when my...

I would leave the database at full recovery and separate the insert into smaller batches. Then perform a transaction log backup between the batches.

If you plan on going ahead...

sqlapprentice (4/28/2011)

---

Just tested on one of our mirrored pair, yes, the secondary file if added on principal is also added on...

In my opinion you should work with your SQL Server DBA since performance tuning is not an easy topic to cover without having some experience with SQL Server.

Will C

MCITP, 2008...