Welcome to Sign in | Join | Help
in
Home Blog Forums

Maintenance Plan - Any Tips for a Newbie.

Last post 03-27-2008, 12:25 PM by AndyJG247. 1 replies.

Sort Posts: Previous Next
  •  02-19-2008, 10:48 AM 1674

    Maintenance Plan - Any Tips for a Newbie.

    Hey Guys,
    I don't know much about SQL Server maintenance. Any tips for me?
    The problem we have most often is that the log file grows really quickly and needs to be manually truncated by myself.
    Usually when there's barely any room left.

    Any pointers, things i should lookout for?  I read about SQL Mail, so i will have to figure out how to set that up.

    Thanks

  •  03-27-2008, 12:25 PM 1793 in reply to 1674

    Re: Maintenance Plan - Any Tips for a Newbie.

    Not sure about maintenance but one tip a SQL guy gave me is always update your tables if you have speed issues.  I think that is what he said, anyone able to correct me if I got that wrong?

    cheers
    Andy
View as RSS news feed in XML


All postings are provided "AS IS" with no warranties, and confer no rights.
Microsoft product screen shot(s) reprinted with permission from Microsoft Corporation.