Hello,
I need to backup SQL server data bases. I plan to use Enterprise manager to
plan regular backup.
There is many databases in the database folder. Can I plan backup only for
master database to backup all databases, or it is necessary to plan backup
for each database in the folder separately?
Thank You for answer
JN

You need to plan for the backup of each database. Whether or not their backup
files should be in the same folder or in a separate folder for eahc database
is matter of your own preference. It doesn't really make much of difference
one way or another.

Linchi

"jn" wrote:

Individually and make sure to backup the logs as well. Think of the data in
the database as base backup + logs=total database state.
Backup the master to save global settings like logins and Database
properties etc.

--
__________________________________________________ ________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
__________________________________________________ __________________________________________



"jn" <jnerad (AT) atlas (DOT) cz> wrote