|
Home > Archive > MS SQL Server security > July 2005 > problems scheduling backups
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
problems scheduling backups
|
|
| bagman3rd 2005-07-11, 8:23 pm |
| 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
PS: I am also having problems posting to this group using IE, but Firefox
allows me to post.
| |
| Sue Hoegemeier 2005-07-11, 8:23 pm |
| Are you using MSDE? I vaguely remember some of what you
describe with a data type error under this scenario.
Did you try just creating a job instead of using maintenance
plans? Writing your own jobs will generally give you more
flexibility that using maintenance plans.
-Sue
On Mon, 11 Jul 2005 13:00:01 -0700, bagman3rd
< bagman3rd@discussion
s.microsoft.com> wrote:
> 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
>
>PS: I am also having problems posting to this group using IE, but Firefox
>allows me to post.
|
|
|
|
|