Microsoft SQL Server, Error: 22022 - social. msdn. microsoft. com I proceeded to shrink the log stopped and started SQL Server and it’s agent than bounced the server and I was able to run a backup without any issues So I really don’t know which of these fixed the problem but its working now
Download Microsoft SQL Server 2008 R2 Evaluation I think the evaluation period for SQL Server 2008 R2 has expired since SQL Server 2012 (even with SP1) has been released and even the pre-release trial of SQL Server 2014 is available
When to reindex? - social. msdn. microsoft. com We have a fairly large database (320 tables, 70GB+) on SQL 2000 where reindexing using 'dbcc dbreindex' currently takes almost 3 hours We are reindexing all tables and dbreindex takes up 80-90% of the system cpu making any other job slow All indexes are setup with a fill factor of 70%