database maintanance plan

Programming and Web Development Forums - MS SQL SERVER - Microsoft SQL Server

Skip to content

database maintanance plan

MS SQL SERVER
Post a reply

    Next

  • 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,
Rupesh
Top

Re: database maintanance plan

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

What edition of SQL 2005?

-- 

Kevin3NF
SQL Server dude

You want fries with that?
 http://www.**--****.com/ 

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

Re: database maintanance plan

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

developer edition

Thanx
Top

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
Top

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 
anywhere

Thanx & Regards,
Rupesh Mondal.
Top

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
Top

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
Top

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
Top

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 
SSMS.

-- 
Andrew J. Kelly    SQL MVP
Solid Quality Mentors
Top

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.
Top

Similar Threads:

1.DBCC REINDEX vs maintanance plan 

Hi,

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 
indexes. 
        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 

hi,

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

any ideas?

Thanks

5.Run Maintanance Plan As Agent Job Step 

Hi Everyone,

I have created a maintanance plan to generate a full database backup with no 
schedule.
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
ACM

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

Post a reply

Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 31 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group