Can't automate backup of a database

When I try and do a maintenace plan to backup all databases there is one tha
t
does not get backedup. All the others seem to work fine. So I try to make
a
new maintenance plan to backup only that database and when I try and create
the plan that database is not in the list of databases. I suppose that is
why it is not working. However I can right click the database and back it u
p
manually with no problems.
Anyone know why it does not show in the list of avaliable databases to be
backed up?
Thanks,
EdIs that a system database or user? If system which database is it?
"Ed R." wrote:

> When I try and do a maintenace plan to backup all databases there is one t
hat
> does not get backedup. All the others seem to work fine. So I try to mak
e a
> new maintenance plan to backup only that database and when I try and creat
e
> the plan that database is not in the list of databases. I suppose that is
> why it is not working. However I can right click the database and back it
up
> manually with no problems.
> Anyone know why it does not show in the list of avaliable databases to be
> backed up?
> Thanks,
> Ed|||It is a user database.
"Bob" wrote:
[vbcol=seagreen]
> Is that a system database or user? If system which database is it?
> "Ed R." wrote:
>|||Ed R. wrote:
> It is a user database.
> "Bob" wrote:
>
Is this a FULL backup or a transaction log backup? What recovery model
is the database using?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The recovery model is simple. When I start a new maintenance task, I drag
the 'backup database task' to the right and then click on it to edit. By
default 'FULL' is selected and greyed out. Then when I try to select the
database from those avaliable it does not show up.
"Tracy McKibben" wrote:

> Ed R. wrote:
> Is this a FULL backup or a transaction log backup? What recovery model
> is the database using?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Lines: 1
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
In-Reply-To: <6BE17578-B64D-496D-96FE-4E4CCAD48E14@.microsoft.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: ncsgate.ncspearson.com 12.106.111.10
Xref: leafnode.mcse.ms microsoft.public.sqlserver.server:10199
Ed R. wrote:
> The recovery model is simple. When I start a new maintenance task, I drag
> the 'backup database task' to the right and then click on it to edit. By
> default 'FULL' is selected and greyed out. Then when I try to select the
> database from those avaliable it does not show up.
>
I guess I don't have any further suggestions... I don't use the
maintenance plan wizards, for this very reason. When one of them
doesn't work, you have no idea why.
You might be interested in this script that I use to do backups:
http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html
It will automatically backup any database on your server, including
transaction logs if appropriate. Schedule it once and forget it.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||A user db doesn't show up in the list only when it's taken offline. Right
click on the database then go to Tasks and click on Bring online then you
should be able to see it.
Another thing, you can't create maintenance plans if you are not a sysadmin
on a server. If you have dbo rights on the database or you are backup
operator you can take the backup from Enterprise Manager but not using
maintenance plans.
If it's none of the above then someone else might need to jump on this issue
to help you out.
Bob
"Tracy McKibben" wrote:

> Ed R. wrote:
> I guess I don't have any further suggestions... I don't use the
> maintenance plan wizards, for this very reason. When one of them
> doesn't work, you have no idea why.
> You might be interested in this script that I use to do backups:
> http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html
> It will automatically backup any database on your server, including
> transaction logs if appropriate. Schedule it once and forget it.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||I would guess it's related to whatever the state is of the
database. There are different database states and statuses
that will keep the database from being displayed in the
maintenance plan screen. Being that it's just the one
database for which a maintenance plan can't be created, I
would suspect it's related to whatever the state or the
other status values are for the database in sys.databases.
-Sue
On Wed, 23 Aug 2006 12:27:01 -0700, Bob
<Bob@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>A user db doesn't show up in the list only when it's taken offline. Right
>click on the database then go to Tasks and click on Bring online then you
>should be able to see it.
>Another thing, you can't create maintenance plans if you are not a sysadmin
>on a server. If you have dbo rights on the database or you are backup
>operator you can take the backup from Enterprise Manager but not using
>maintenance plans.
>If it's none of the above then someone else might need to jump on this issu
e
>to help you out.
>Bob
>"Tracy McKibben" wrote:
>sql