Re: Problem with my SQL 2000 Maintenance plans.
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/19/04
- Next message: Mark Allison: "Re: Alter Column"
- Previous message: Tibor Karaszi: "Re: Alter Column"
- In reply to: Russell: "Re: Problem with my SQL 2000 Maintenance plans."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 12:01:22 +0200
I wouldn't use maint plan for this.
As for reindex, read http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
and I suggest you apply the script you find in Books Online, DBCC SHOWCONTIG (make sure you are
using the most recent update of Books Online).
As for shrink: http://www.karaszi.com/SQLServer/info_dont_shrink.asp.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Russell" <Russell@discussions.microsoft.com> wrote in message news:8F3F40FD-740C-431B-A7DB-95DA17F5CC67@microsoft.com... > Thanks for that I will make that change. What are the best settings for the > optimisation part of the plan. Currently it confiured as: > > 'Reorganize Data and Index Pages' to change the free space per page to 10% > 'Remove unsed space from database files' is checked, Shrink databse is set > to 50Mb and 10% free space to remain after shrink. > > It is set to do this one a week and most of the datbases are 2 to 3 Gb with > a few a bit bigger around 18 Gb. > > "Tibor Karaszi" wrote: > >> Uncheck the "attempt to repair minor problems" for your maint plan. This option is a bad idea in >> the >> first place. If you do have a problem in the database, you want to be alerted so you can do >> root-cause analysis and so on (http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp). The >> option will most probably be removed in next version of SQL Server. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> >> >> "Russell" <Russell@discussions.microsoft.com> wrote in message >> news:FA9647AB-08DB-4AC9-AE48-3ABD6606BF48@microsoft.com... >> >I have just started a new job and am in the process of sorting out the >> > database backups. On every server there seems to be the same issue with the >> > integrity step. The error it is giving is when it is carrying out the 'Check >> > Data and Index Linkage' the error is 'Repair Statement not processed.Database >> > needs to be in single user mode.' Is there anyway around this?, or will it >> > just be down to people or the replication agents being connected to the >> > database at the time the integrity checking is taking place. >> >> >>
- Next message: Mark Allison: "Re: Alter Column"
- Previous message: Tibor Karaszi: "Re: Alter Column"
- In reply to: Russell: "Re: Problem with my SQL 2000 Maintenance plans."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
