Checking out the RS configuration is one of my tasks this morning, and the web server is a different server than the database server.

Thanks for the input.

Deana

The plan to move between simple recovery for dbcc, stats, rebuilds, etc. and full recovery is testing poorly again. I did find out that you can do this as...

Good suggestion there. I have done this with SQL Server 2000 maintenance plans, but it tested poorly with SQL Server 2005 on the development server. The maintenance plan...

Thanks for that info. I have been pursuing a two-pronged strategy of more disk space and reducing the transaction log size. I should get the extra drive next...

How true, how true. I have a similar situation with the dev server so i'll practice first on it.

Thanks for your help.

Deana

Thanks for the offer of assistance. I checked this morning -- the mdf is 20GB and the ldf is 28GB. No heavy user transactions running at night except...

I'm not sure what the initial size was, but I have expanded the log size 2-3 times over the past 3 months. Your comment about shrinking the log is...

I am running into a similar situation and need to figure out how best to proceed. The database houses GIS data and is large. There would be few...

Change the logins to SQL Server authentication? 

Deana

Thanks for the information.  Could you explain a little more about what it is supposed to do?

At my first reading of this, I'm not sure that I can do it. ...