Backup

I have a need to backup about 100 database on one server.
What is the best way to do it?
I tried using backup and restore, but in this I have to
give each database name, I would like to avoid entering
the each database to be backedup. Can I automate this?
I also tried copying .mdb and .ldb files and restore onto
the other server. But this requires creating each of the
databases and specifying location to .mdb and .ldb files.
I was wondering if somebody could let me know a way by
which I can easily take backup of all my databases at
once with minimal manual intervention.
Thank you in advance,
MeDid you consider the Maintenance Wizard? Also, for restore, you might want t
o look at (possibly adapting the
code a bit): http://www.karaszi.com/SQLServer/ut...all_in_file.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Me" <anonymous@.discussions.microsoft.com> wrote in message news:299d01c47e2c$dbb1f430$a3012
80a@.phx.gbl...
> I have a need to backup about 100 database on one server.
> What is the best way to do it?
> I tried using backup and restore, but in this I have to
> give each database name, I would like to avoid entering
> the each database to be backedup. Can I automate this?
> I also tried copying .mdb and .ldb files and restore onto
> the other server. But this requires creating each of the
> databases and specifying location to .mdb and .ldb files.
> I was wondering if somebody could let me know a way by
> which I can easily take backup of all my databases at
> once with minimal manual intervention.
> Thank you in advance,
> Me|||Hi,
Can you try restore of msdb database on the target in the beginning?
This has all the info regarding the individual database. Any one from
microsoft-
suggest if Microsoft do not recommend restoring the msdb db.
Thanks,.
Chandan
"Me" wrote:

> I have a need to backup about 100 database on one server.
> What is the best way to do it?
> I tried using backup and restore, but in this I have to
> give each database name, I would like to avoid entering
> the each database to be backedup. Can I automate this?
> I also tried copying .mdb and .ldb files and restore onto
> the other server. But this requires creating each of the
> databases and specifying location to .mdb and .ldb files.
> I was wondering if somebody could let me know a way by
> which I can easily take backup of all my databases at
> once with minimal manual intervention.
> Thank you in advance,
> Me
>|||All,
Thank you for the reply!
I will try with this code or write my own.
-Me

>--Original Message--
>Did you consider the Maintenance Wizard? Also, for
restore, you might want to look at (possibly adapting the
>code a bit):
http://www.karaszi.com/SQLServer/ut...re_all_in_file.
asp
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Me" <anonymous@.discussions.microsoft.com> wrote in
message news:299d01c47e2c$dbb1f430$a301280a@.phx.gbl...
server.[vbcol=seagreen]
onto[vbcol=seagreen]
the[vbcol=seagreen]
files.[vbcol=seagreen]
>
>.
>