I  think the article you mentioned probably only applies to the restore of a db. I am working off of this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_1_013_9t0p.asp

Let me know what you think.

thanks

What material are you guys using? BOL?

I am sorry that link was not the right one . You can use the following where it shows you how to truncate and shrink.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;272318

support.microsoft.com/?id=307487

How about backing up using maintenance plan and restoring manually?

Also I dont see a log shipping monitor on my monitoring instance.

Thanks for clarifying. This makes sense.

dont you think it would cause defrag if we shrink post index rebuild? are you only suggesting shrinking log file?

I am thinking about this as well. Is there any forum here dedicated only to MCTS 2005?

very interesting. how about running DBCC SHRINKDATABASE  before rebuilding indexes every night?

I dont believe there is any such file. However you right click on the sql server instance in enterprise manager and click properties. Under memory tab you can choose the...

Hello Watson

Do you get free tuition at northwestern if you are working there?

thanks

Just wondering what the average of a sql server dba with 7 years of experience in both Oracle and SQL Server?

Did you install SQLSPY on the the server or does it from a server with sql server client?

http://support.microsoft.com/default.aspx?scid=kb;en-us;870617