Make IT Complete

Technical Ramblings From an IT Professional

Entries Tagged ‘SQL Server’

Database Maintenance Plans and Backup Exec

Sep.25, 2008 in SQL Server Leave a Comment

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 [...]

Tags: , ,

Shrinking tempdb

Sep.08, 2008 in SQL Server Leave a Comment

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 [...]

Tags:
  

Welcome to the Show

This is the makeitcomplete.com blog. This blog has been created to give me an outlet to share technical and business ideas and issues that may not be directly related to the makeitcomplete.com service offerings. I have found that I have a great desire to share with the world the knowledge that I have gained. For years I have have been taking from the Internet and not giving back enough. Now is the time. My goal is to post the problems that I run into and provide you with my answers. Along the way maybe you will have something that you want to chime in on. The blog will be open to registered users to post into. I welcome your comments and feedback.