MaintenancePlan - task order

Hello,
I created one maintenance plan with one schedule, it includes several
tasks. How I can change order on with they are executed, graphical
moving task didn't change order.
--
Best regardsYou have lines with arrows between the tasks. They define the flow. Remove your current lines (the
one you need to re-arrange) and draw new lines, to your liking.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<anxcomp@.gmail.com> wrote in message news:1194381069.963177.83560@.50g2000hsm.googlegroups.com...
> Hello,
> I created one maintenance plan with one schedule, it includes several
> tasks. How I can change order on with they are executed, graphical
> moving task didn't change order.
> --
> Best regards
>|||Hello Tibor :)
> You have lines with arrows between the tasks. They define the flow. Remove your current lines (the
> one you need to re-arrange) and draw new lines, to your liking.
Are you sure this working, I tray arrange flow between the tasks use
lines, but logs show me that tasks are executed on different order.
--
Best regards|||Yes, it should work. I can't say why it isn't working for you, except for guesses like your not
editing the correct package... Sorry :-(
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<anxcomp@.gmail.com> wrote in message news:1194388800.134252.68680@.o38g2000hse.googlegroups.com...
> Hello Tibor :)
>> You have lines with arrows between the tasks. They define the flow. Remove your current lines
>> (the
>> one you need to re-arrange) and draw new lines, to your liking.
> Are you sure this working, I tray arrange flow between the tasks use
> lines, but logs show me that tasks are executed on different order.
> --
> Best regards
>
>|||You are right, it is working. Sorry and thanks, my mistake. I looked
at order on log files. SQL Server wrote on wrong order, but when I
looked at individual start and stop date for each tasks, everything is
on right order.
Thank for your help.
--
Regards,
anxcomp|||Glad you got it working.. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<anxcomp@.gmail.com> wrote in message news:1194459342.715819.182790@.d55g2000hsg.googlegroups.com...
> You are right, it is working. Sorry and thanks, my mistake. I looked
> at order on log files. SQL Server wrote on wrong order, but when I
> looked at individual start and stop date for each tasks, everything is
> on right order.
> Thank for your help.
> --
> Regards,
> anxcomp
>

Maintenance Plan/Backup Question

I'm having a problem on a remote server with what I think is a Maintenance
Plan that seems to be doing an endless backup. My db is about 3GB, the
backup file (.bak) of the database keeps growing and eventually will exceed
the amount of disk available. There is over 30GB of available space for
backups.
I've resorted at last to performing a manual backup and deleting all
Maintenance Plans from the database. The manual backup is approximately
2.1GB.
After 24 hours, the automated backup is still growing. On the database
properties page, the date/time for the last database backup keeps being
updated about every two hours.
Is it possible that backup operations are queued, and given time the
operations will cease on its own? Anyone have any suggestions on how to
stop the backup operation so that I can recreate a maintenance to automate
my database backups?
> I'm having a problem on a remote server with what I think is a Maintenance Plan that seems to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of the database keeps growing
Probably not maint wiz. Probably someone coded BACKUP DATABASE and forgot to do WITH INIT (NOINIT =
append is the default).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Don Delk" <delk@.intransit.dot.gov> wrote in message news:ePe%23IJ4vFHA.2164@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem on a remote server with what I think is a Maintenance Plan that seems to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of the database keeps growing
> and eventually will exceed the amount of disk available. There is over 30GB of available space
> for backups.
> I've resorted at last to performing a manual backup and deleting all Maintenance Plans from the
> database. The manual backup is approximately 2.1GB.
> After 24 hours, the automated backup is still growing. On the database properties page, the
> date/time for the last database backup keeps being updated about every two hours.
> Is it possible that backup operations are queued, and given time the operations will cease on its
> own? Anyone have any suggestions on how to stop the backup operation so that I can recreate a
> maintenance to automate my database backups?
>
|||Hello,
I suggest that you check SQL server agent jobs. You may perform the
following steps to check which job perform a backup:
1. Double-click Management> SQL Server Agent > Jobs in SQL server
Enterprise Manager(SEM).
2. Locate the jobs in the right window.
3. Double-click the job. Check the steps and the schedules for the job to
see what job perform a backup every two hours.
4. Edit the job step.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Maintenance Plan/Backup Question

I'm having a problem on a remote server with what I think is a Maintenance
Plan that seems to be doing an endless backup. My db is about 3GB, the
backup file (.bak) of the database keeps growing and eventually will exceed
the amount of disk available. There is over 30GB of available space for
backups.
I've resorted at last to performing a manual backup and deleting all
Maintenance Plans from the database. The manual backup is approximately
2.1GB.
After 24 hours, the automated backup is still growing. On the database
properties page, the date/time for the last database backup keeps being
updated about every two hours.
Is it possible that backup operations are queued, and given time the
operations will cease on its own? Anyone have any suggestions on how to
stop the backup operation so that I can recreate a maintenance to automate
my database backups?> I'm having a problem on a remote server with what I think is a Maintenance Plan that seems
to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of the databa
se keeps growing
Probably not maint wiz. Probably someone coded BACKUP DATABASE and forgot to
do WITH INIT (NOINIT =
append is the default).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Don Delk" <delk@.intransit.dot.gov> wrote in message news:ePe%23IJ4vFHA.2164@.TK2MSFTNGP10.ph
x.gbl...
> I'm having a problem on a remote server with what I think is a Maintenance
Plan that seems to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of th
e database keeps growing
> and eventually will exceed the amount of disk available. There is over 30
GB of available space
> for backups.
> I've resorted at last to performing a manual backup and deleting all Maint
enance Plans from the
> database. The manual backup is approximately 2.1GB.
> After 24 hours, the automated backup is still growing. On the database pr
operties page, the
> date/time for the last database backup keeps being updated about every two
hours.
> Is it possible that backup operations are queued, and given time the opera
tions will cease on its
> own? Anyone have any suggestions on how to stop the backup operation so t
hat I can recreate a
> maintenance to automate my database backups?
>|||Hello,
I suggest that you check SQL server agent jobs. You may perform the
following steps to check which job perform a backup:
1. Double-click Management> SQL Server Agent > Jobs in SQL server
Enterprise Manager(SEM).
2. Locate the jobs in the right window.
3. Double-click the job. Check the steps and the schedules for the job to
see what job perform a backup every two hours.
4. Edit the job step.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.