Search Books Online for the heading "Replication and Database Mirroring" and read that first. This should give you what you need. Once you have read that check back...

This is a long shot and I doubt it helps, but just in case -- have you tried:

DBCC UPDATEUSAGE (0);

GO

This has had impact on my free space and space used...

Yeah, sounds like there's binary data if you only compressed from 30 GB to 20 GB. I have seen compression rates as great as 90% depending upon the data...

Even if they type in the config file path as a parameter on the command line for DTExec? Man, that's clueless. Well, not sure what I can tell...

If you are running the SSIS as a SQL job you can map the config file location as an attribute of the job step. Alternatively, you can supply the...

Books Online has a good writeup on this. Basically you have to set up log shipping on both mirror sites BEFORE you have a failover in production. When...

Did you set up both nodes of the mirroring to log ship? You have to fail to the mirror and set it up as a primary, THEN fail back...

GilaMonster (7/28/2010)

On SQL 2005+ rebuilding the cluster does not rebuild nonclustered...

If you do an ALTER INDEX ALL on the table, that will take care of it all for you. You would in that command do the clustered index first,...

Do not under any circumstances require DB_Owner rights to a database if you are designing an application. The app account should not need DDL admin to run the system...

The article says to use the values only; the extra 8k multiplication is adding too much to your calculation. I see no call for expanding the pages out in...

Sounds like his permissions to the metadata on the server got yanked....?

Download and run this against your 2000 server:

http://www.microsoft.com/downloads/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en

There really is no better way to get a quick summary of potential problems in the upgrade.

SP1 is only for SQL 2008 (10.0.x). R2 is 10.5.x and is a "newer" version than straight SQL 2008. There is no service pack 1 yet for R2.

Unless something other than SQL is being used by the server, 50% to OS is too much; you're wasting memory that SQL could use. 120MB is too small though,...