>It is possible to backup all databases at once, using MSSQL:
>However, I advise (if possible) to use
>MSSQL:master
>MSSQL:db_name1
>MSSQL:db_name2
>instead. This has the advantage that incremental backups of the databases
can
>be made ( backups of only the transaction logs ), next to full backups.
When not
>specifying the database name ( just 'MSSQL:' ), you can only make full
backups!

Just a cautionary note, if you have database admins that keep creating new
databases then you will need to stay on top of this.  If you can get away
with it, it is much easier to just do the full backups.  In my office I
think the database admins are starting to outnumber the rest of us so it is
impractical to name them individually.

Julia


The information contained in this electronic message is for the exclusive
and confidential use of the addressee.  Any other distribution, use,
reproduction or alteration of the information contained in this electronic
message, by the addressee or by any other recipient, without the prior
written consent of Phillips, Hager & North Investment Management Ltd. is
strictly prohibited.  If you have received this electronic message in error,
please notify the sender.

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=