I have an old SQL 2000 database on a critical system which is in need of attention. I am new to supporting SQL, so bare with me. The combined database sizes are about 60GBs total. There is a 'History' database which is about 32GBs. all
of the rest are quite small with the exception of tempdb. The tempdb log file is tiny. The tempdb mdf file currently is about 22GBs. Space is limited on the server and backups fail when the 'history' database tries to backup.
Here's some data:
View Complete Post