Results 1 to 4 of 4

Thread: SQL Maintenance

  1. #1
    Join Date
    Jan 2003
    Location
    Texas
    Posts
    4

    Question Unanswered: SQL Maintenance

    While using SQL 6.5 my company adopted the practice of Rebooting the SQL Server once a week. When we upgraded to 7.0 we kept the reboot schedule for a while but now have moved away from it. Is there any reason that the SQL DB should be restarted?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    No - just the usual adminstrative reasons - service packs, hot fixes ... and of course the emergency situations. There have been cases of memory leaks and 100% cpu usuage but if you keep up with service packs you will be ok.

  3. #3
    Join Date
    Jan 2003
    Location
    Texas
    Posts
    4
    Thanks for the reply.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Happy to help and good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •