+ Post New Thread
Results 1 to 7 of 7
Windows Server 2000/2003 Thread, SQL Server 2000/2005 in Technical; Hi What tasks should i be doning with SQL Server to maintain the databases or manage it in general? SQL ...
  1. #1

    Join Date
    May 2008
    Posts
    518
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15

    SQL Server 2000/2005

    Hi

    What tasks should i be doning with SQL Server to maintain the databases or manage it in general? SQL isnt my strongest point by a long way so i think nows the time to put that right!

    Im not sure if there are routine maintainance tasks that i should be running to keep the databases running at optimal condition.

    Many Thanks!

  2. #2

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,859
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    Back it up. Apart from that, it will look after itself.

  3. #3

    Join Date
    May 2008
    Posts
    518
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15
    Thanks Powdarrmonkey. Nice and simple. The way i like it!

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,844
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    depending on usage levels you might want to control the rate of growth of the LDFs

  5. #5

    Join Date
    May 2008
    Posts
    518
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15
    what are LDFs?

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,844
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    it's a transaction log file. it accompanies the main db file the mdf.
    periodically the transactions are written into the main mdf file and the ldf is truncated.

    it usually sorts itself out quite well, but there can be instances when it doesn't truncate well, or if the volume of transactions is really high, it can grow too quickly.

    there are options to have it increase by a fixed percentage e.g. 10% or to increase by a fixed amount of disk space e.g. 100MB. i prefer the latter. it grows to that fixed size and then any space within is used up until it is either truncated or needs to grow again.

    we had this as a massive problem on our school's SIMS database once because the backups weren't correctly consolidating the data.

  7. #7
    robins's Avatar
    Join Date
    May 2007
    Posts
    44
    Thank Post
    15
    Thanked 5 Times in 5 Posts
    Rep Power
    15
    You can opt to record log dumps to enable reverting back to perhaps hourly logs of data conditions or indeed to precisely return to an individual point in time. Usually this level of recovery is more than schools really need.
    To aid performance you could also...
    reindex tables (both in your own databases and the system databases master and msdb).
    update statistics on stored procedures (help bits of code run at optimal speed.
    shrink database device files.
    The scheduled job wizards offer these options and more - worth experimenting with out of hours though can starve other services without giving any great benefit.

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle & SQL Server 2005
    By ahunter in forum Virtual Learning Platforms
    Replies: 16
    Last Post: 31st October 2008, 12:19 PM
  2. SIMS SQL Server 2005 re-install
    By philserre in forum MIS Systems
    Replies: 6
    Last Post: 14th October 2008, 08:44 PM
  3. SQL Server 2005 Backups Problem
    By ICTNUT in forum Windows
    Replies: 0
    Last Post: 7th July 2008, 09:53 AM
  4. Sims SQL 2005 upgrade on a new server?
    By zag in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 08:46 AM
  5. Replies: 12
    Last Post: 22nd October 2007, 07:15 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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