Any errors in the SQL Server Log or the application / system log for Windows? Very curious.

I would start with this link which is really BOL. I think you will find it to be pretty straightforward.

One note though, when they are mentioning using another server...

Sorry, just trying to understand a bit though, are you getting complaints about performance as part of the audit data collection or as part of the "reporting" of that data?...

Pro's - active queries aren't slowed down as the original index is still in place. So, activity can continue as "normal" during the rebuild process (for the most part).

Con's -...

There is a really great blog post by Kimberly Tripp here and here. It would be worthwhile to read these and consider the things that are stated. Most times people...

Sorry, should have included this with previous reply - From BOL;

There are two options for configuration when you place the secondary database in standby mode:

You can choose to have...

sunny Brook (2/6/2009)

If you do hourly log-shipping, the DB on your Reporting server...

Check out Paul Randal's blog about corrupting a database....

Yeah, those guys seem to know what they are doing. 😛

Check out this blog post from the CSS engineers. I think it will give you everything you need to check and go farther if you need.

Not sure if you...

The production server will only incur a small hit with the log backups but that will provide you with better protection throughout the day and will eliminate the possibility of...

Then exercising hourly log backups may be the way to go and use that for log shipping to the other server. Have the logs applied at night and allow for...

When you switch the database to full recovery model you need to implement a proper backup plan for the transaction log to keep the log file size manageable. However, with...

From BOL:

------------------------------------------------------------------------------------------

The Snapshot Agent performs the following steps:

Establishes a connection from the Distributor to the Publisher, and then takes locks on published tables if necessary:

For snapshot publications, locks are held...

So, when you look at the output of sp_spaceused is the output not what you expect for data structures and index structures?

Might be wise to take GSquared's advice as...