I know that I need to do Integrity Checks, Index Rebuild/Reorganize, Backups, Statistic Updates...

That's all that comes to mind. What I'm wondering is, what needs to be maintained and how...

Microsoft states how much storage different data types use. http://msdn.microsoft.com/en-us/library/ms187745.aspx for instance shows int, bigint, smallint, and tinyint. And they tell how to get most of...

So I think the number of concurrent jobs would be limited by the 'max worker thread' setting. And from what I can find with 24 cores that would be...

I don't know why SETUSER is being invoked but it looks like it is being invoked from an account that does not have sysadmin role. Did you try putting the...

The reason I need to be doing this is because of a failover solution we have. It was originally built when we were running everything on SQL server 2000....

You can in fact log ship to a higher version of SQL using the no recovery option. You just are unable to read any data from the database untill...

I have Replication from sql 2000 to sql2008 setup, it has worked with out issue for me. Just added the subscriptions like normal and everything worked.

take a look at method b in this article

http://www.replicationanswers.com/AddColumn.asp

and at sp_repladdcolumn - http://msdn.microsoft.com/en-us/library/aa239331(SQL.80).aspx

http://www.sqlservercentral.com/scripts/Miscellaneous/31893/

was written for sql 2005 but probably a decent place to start.

even more interesting is that the sp_repldropcolumn command seems to update the stored procedures for replication. Which leads me to think that after I have issued the sp_repldropcolumn command...

If you go to enterprise manager and right click the database name and go all tasks, shrink database then click on the Files button. You can specify a size...

thanks for the quick reply, and those links.

you might also want to check into the settings you have for automatic file growth, and look at what caused the database to grow to that size in the first...

Do you know which files have grown? if its just the log files then you will need to take a transaction log backup and right after that finishes you...

so even using everything i have found for the amount of space different data types use still was not getting very accurate results. Was some where around 80% of...