Backing Up Muliple Databases in Same Instance

I've 6 databases in the same instance which I wish to se a backup routine
for. How can I select all the databases at a go and create a backup procedure
just once in enerprise manager. I tried highlighting all he databases, but
each time I click backup up. he sysem comes up with one database at a time
for me o create backup for.
--
RegardsIs this something you want to schedule or do only once?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
> I've 6 databases in the same instance which I wish to se a backup routine
> for. How can I select all the databases at a go and create a backup procedure
> just once in enerprise manager. I tried highlighting all he databases, but
> each time I click backup up. he sysem comes up with one database at a time
> for me o create backup for.
> --
> Regards|||I want to schedule it.
--
Regards
"Tibor Karaszi" wrote:
> Is this something you want to schedule or do only once?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
> news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
> > I've 6 databases in the same instance which I wish to se a backup routine
> > for. How can I select all the databases at a go and create a backup procedure
> > just once in enerprise manager. I tried highlighting all he databases, but
> > each time I click backup up. he sysem comes up with one database at a time
> > for me o create backup for.
> > --
> > Regards
>|||Create a Maintenance Plans. The regular backup dialog doesn't support selecting multiple databases,
but a Maint Plans does.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
news:7EFD5154-BBB8-40D0-8791-51EF2B744CC3@.microsoft.com...
>I want to schedule it.
> --
> Regards
>
> "Tibor Karaszi" wrote:
>> Is this something you want to schedule or do only once?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
>> news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
>> > I've 6 databases in the same instance which I wish to se a backup routine
>> > for. How can I select all the databases at a go and create a backup procedure
>> > just once in enerprise manager. I tried highlighting all he databases, but
>> > each time I click backup up. he sysem comes up with one database at a time
>> > for me o create backup for.
>> > --
>> > Regards
>>