problems scheduling backups
From: bagman3rd (bagman3rd_at_discussions.microsoft.com)
Date: 07/11/05
- Previous message: Mike Epprecht \(SQL MVP\): "Re: SQL Server 2000 SP4 / Security Patches"
- In reply to: Mike Epprecht \(SQL MVP\): "Re: SQL Server 2000 SP4 / Security Patches"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 11 Jul 2005 12:31:02 -0700
I am having problems scheduling backups. It seems pretty straight-forward,
but will not work. I have tried a few different approaches.
1. in EM, under Management>Database Maintenance Plans, I have tried to set
up a Database Maintenance Plan, but whenever I try to schedule a backup, it
acts like it is fine, but when you close the DM plan and re-open the plan,
the schedule always is gone and does not exist. I have also gotten errors
stating that the plan could not be created because of a "int to smallint"
conversion error, which absolutely baffles me.
2. In EM, under Management>Backups, I have tried to creat a backup with a
schedule, but once again, the schedule disappears as soon as I close the
dialog box and open it again.
3. I have right clicked on the db, go to all tasks>backup database, but I
encounter the same problem in that I cannot schedule a backup.
The backup itself works fine but I cannot seem to schedule any backup.
Please help. This is driving me nuts!!!
Archer
- Previous message: Mike Epprecht \(SQL MVP\): "Re: SQL Server 2000 SP4 / Security Patches"
- In reply to: Mike Epprecht \(SQL MVP\): "Re: SQL Server 2000 SP4 / Security Patches"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|