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.