Make IT Complete

Technical Ramblings From an IT Professional

Entries Tagged ‘SQL Server’

Database Maintenance Plans and Backup Exec

Assuming you have the SQL Agent installed on your media server then yes Backup Exec will / can backup your live SQL databases.
From a DR point of view you don’t need the Maintenance Plan jobs, however if you have the storage capacity available I personally would recommend keeping them, simply due to the ease in [...]

Shrinking tempdb

From time to time we find that the tempdb database grows to a very large size.  This database should maintain itsself but of course things that should don’t.
Here is the method that I use to shrinl the tempdb when it has grown out of control.
dbcc shrinkdatabase (tempdb, 10)
I often find that I need to run [...]