Cannot create Recurring backup

I am not able to create a recurring backup job on sql2005. There is no
schedule option when you right click on database then tasks-->backup, also
when I try to do it thru maintenance plan I am not able to see my databases.
Can someone tell me how to resolve this problem?
Thanks in advance for any help-RobRob wrote:
> I am not able to create a recurring backup job on sql2005. There is no
> schedule option when you right click on database then tasks-->backup, al
so
> when I try to do it thru maintenance plan I am not able to see my database
s.
> Can someone tell me how to resolve this problem?
> Thanks in advance for any help-Rob
Don't use the pointy-clicky interface, instead script your backups.
Create a SQL Agent job that uses the BACKUP DATABASE/BACKUP LOG commands.
http://realsqlguy.com/twiki/bin/vie...realsqlguy.com|||Rob wrote on Wed, 12 Jul 2006 13:39:02 -0700:

> I am not able to create a recurring backup job on sql2005. There is no
> schedule option when you right click on database then tasks-->backup,
> also when I try to do it thru maintenance plan I am not able to see my
> databases. Can someone tell me how to resolve this problem?
> Thanks in advance for any help-Rob
Did you restore these databases from a SQL2000 or older server? If so, they
have compatibility set to 80 or lower, and the Maintenance Plan will ignore
them. Change each database to compatibility 90 and they'll then be
selectable in the GUI maintenance plan.
Dan