Tuesday, February 14, 2012

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,
Me
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/uti...ll_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
|||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/uti...e_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...[vbcol=seagreen]
server.[vbcol=seagreen]
onto[vbcol=seagreen]
the[vbcol=seagreen]
files.
>
>.
>

No comments:

Post a Comment