I do append to the same file for ease of file cleanup later when I do the overwrite.

as this might not be the most perfect way it works. I...

ok here is where I'm settling.

1. run db integrity check system db

2. run db integrity check users db

3. backup db full

4. backup db log file (overwrite)

5. set db bulk mode

6....

the reason I was doing the integrity check twice is because I taught to run it first. Then ran it again because of this comment:

http://ola.hallengren.com/frequently-asked-questions.html

Scheduling:

"I recommend that...

So let me throw my weekly maintenance plan order to you and please provide any feedback.

1. run db integrity check system db

2. set db bulk mode

3. run db integrity check...

Perfect! I like this solution and...

ok I modified the top of the SP found under master dbo.indexoptimize

-- @UpdateStatistics nvarchar(max) = NULL,

@UpdateStatistics nvarchar(max) = ALL,

-- @OnlyModifiedStatistics nvarchar(max) = 'N',

@OnlyModifiedStatistics nvarchar(max) = 'Y',

-- @StatisticsSample int = NULL,

@StatisticsSample...

I'm thinking of just running the standard ALL FULL update statistics I found in the Maintenance Plan where I would modify this to ALL but do you think there is...

I see thanks!

you lost me here.

I think you meant I could run the command I pasted. Not sure though.

would I use the code in the job that runs the stored procedure?

example:

sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "EXECUTE [dbo].[IndexOptimize] @databases = 'USER_DATABASES', @LogToTable = 'Y'" -b

or...

I do not see an execute package task in sql 2005 options for maintenance plans.

How can I execute these jobs so that the plan waits?

Is there a way to maybe...

Ok I think I almost have everything up to snuff finally but a few last questions. I want to use these provided index and integrity check operations from my...

I will set it to 3000 for 3GB I believe it is only using about 1GB during the week at the most so 3GB should give it some room.

Is there...

I do appreciate the information everyone has provided.

I changed the daily code to run: