database maintanance plan



  • 1. Good documentation tool
    hi all, if anybody could direct me to a free DB documentation tool for SQL2K that'll be great. Since we're running out of budget (usual year end crunch, blah blah!), we cannot budget for buying any new tool...if anyone also knows diff tools that could be used within SQL2K, pls suggest in brief how to make use of it for documenting Tables, Triggers, Relation Diagram and Data Dictionary TIA
  • 2. modifing a running trace
    Is there a way to modify a running trace without stopping and re-createing it? I have a trace running for SOX Audting and I need to add a new user to be traced. I created the trace in a script not the GUI in EM. When I created it I used the following code to ignore this user and now I need to add him to the trace: exec sp_trace_setfilter @TraceID, 11, 0, 7, N'jsisserly' I have the trace writing out to files, and I am up to approx #1000. If I stop the trace I will need to move the file out of the directory, and re-start at #1. I am hoping to avoid renumbering. TIA, Joe
  • 3. Performance Counters Disappear
    I am using logman to stop and start a performance log for the SQL counters as well as some Windows counters. This process works well for several weeks and then it drops all the counter except for a few, it leave disk queue lenght and memory/pages sec. The only I have found to restore the counters is to rebuild the counter log. Any ideas or suggestions would be appreciated.

database maintanance plan

Postby UnVwZXNoIE1vbmRhbA » Thu, 31 Jan 2008 16:53:00 GMT

I have a sa login in sql server 2005,still the option of "new database 
maintanance plan" is not visible to me,reply me asap

thanx & Regards,

Re: database maintanance plan

Postby Kevin3NF » Thu, 31 Jan 2008 21:58:49 GMT

What edition of SQL 2005?


SQL Server dude

You want fries with that?

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

Re: database maintanance plan

Postby UnVwZXNoIE1vbmRhbA » Fri, 01 Feb 2008 18:04:00 GMT

developer edition


Re: database maintanance plan

Postby Andrew J. Kelly » Sat, 02 Feb 2008 00:21:09 GMT

Do you have the latest service pack installed?  Earlier versions required 
that you also have Integration Services installed and I am guessing that is 
not so you do not have the option for it.

Andrew J. Kelly    SQL MVP
Solid Quality Mentors

Re: database maintanance plan

Postby UnVwZXNoIE1vbmRhbA » Sat, 02 Feb 2008 13:33:02 GMT

i had service pack 2 installed, but i dont find integration service option 

Thanx & Regards,
Rupesh Mondal.

Re: database maintanance plan

Postby UnVwZXNoIE1vbmRhbA » Sat, 02 Feb 2008 18:25:00 GMT

sp 2 is installed ,i did found new intregration project in business 
intelligence section,that means integration service is installed,then why the 
option of "new database maintainance plan" is not showing,please help asap

Re: database maintanance plan

Postby Andrew J. Kelly » Sun, 03 Feb 2008 01:07:14 GMT

If I remember correctly you also needed to enable OLE Automation option in 
the Surface Area Configuration Utility.

Andrew J. Kelly    SQL MVP
Solid Quality Mentors

Re: database maintanance plan

Postby Jeffrey Williams » Sun, 03 Feb 2008 13:05:07 GMT

Are you sure you are connecting to a 2005 instance?  In the object 
explorer, next to the name of the server connection - what is the 
version number?  Should be 9.0.xxxx

Re: database maintanance plan

Postby Andrew J. Kelly » Mon, 04 Feb 2008 04:45:49 GMT

Good point. If this is SQL 2000 you can not create maintenance plans using 

Andrew J. Kelly    SQL MVP
Solid Quality Mentors

Re: database maintanance plan

Postby UnVwZXNoIE1vbmRhbA » Wed, 06 Feb 2008 19:13:01 GMT

Thank you guys a lot ,my problem solved,by enabling OLE Automation ,now its 
showing the option,i will give u guys more trouble by asking other questions
Thanks a lot

Rupesh Mondal.

Similar Threads:

1.DBCC REINDEX vs maintanance plan


I would like to reindex all the tables in my database by using a  job
instead of a maintenance plan. In a maintenance plan this is possible with
the checkbox: "reorganize data and index pages". How can I do the same thing
in a script without using DDBC REINDEX for every table?

2.maintanance plan

I dont know is this the correct forum to ask this question. I am creating a 
maintanace plan for rebuilding an index. The table is having 7 non clustered 
indexes. Out of that only one index is getting fragmented a lot. I want to 
create a maintanance plan to rebuild that particular index. I have options to 
choose database name and table/view name in maintanance plan wizard. There is 
no option to choose the index. So the maintanance plan will rebuild all the 7 
        Is there any way to create a maintanance plan for rebuilding just 
one index.

3.replace maintanance plan optimization

4.SQL2005 no sp maintanance plan error


I got the error for an mainanance plan to backup a database to the local 
Unable to start execution of step 1 (reason: line(1): Syntax error).  The 
step failed.

any ideas?


5.Run Maintanance Plan As Agent Job Step

Hi Everyone,

I have created a maintanance plan to generate a full database backup with no 
I have then created a new Agent job with multiple steps, most of the steps 
execute TSQL and these seem to be working. One of the job steps is to execute 
the Full database backup SSIS package generated by the Maintanance plan. This 
step executes in less than 1 second without an error and does not generate 
the backup.
If I execute the maintanance plan directly via the right click EXECUTE 
command it works as expected.
I have checked to ensure that the Agent job owner is a member of the 
sysadmin so I don't think access rights are an issue.
Does anyone have any ideas?

I have considered copying the TSQL the maintanance plan generated and 
executing this in the step instead of the SSIS package but I would like to 
know why my existing configuration will not work.

Please help

6. No ability to create maintanance plan in sql server 2005

7. Database Table Maintanance by Text File

8. PROBLEM: Database Mainence plan "All user Databases" missing database



Who is online

Users browsing this forum: No registered users and 31 guest