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 to look at (possibly adapting the
code a bit): http://www.karaszi.com/SQLServer/util_restore_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...
> 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/util_restore_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...
>> 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
>
>.
>