Hi,
We are using the SQL Connect Agent (1.1.1a) to back up databases that
reside on SQL Server 6.5 and 7.0. There are two devices for each user
database, one for data, one for the transaction log. We are performing a
full backup of the each database and log every night (using the /BACKUPFULL
command line switch). It is possible for users to be active in the
databases while they are being backed up. I'm trying to get an answer to
the following questions:
1) How much of the transaction log is backed up? Is it the contents of the
log at the start of the backup process? Assuming that transactions are
being started and/or committed during the backup process, will the log
entries created be included in the backup?
2) Does the version of SQL Server being backed up affect the answer to the
above questions? If so, how?
Other relavant info(?): ADSM Server - NT 4, SP3, ADSM 3.1.1.3
SQL Servers - NT 4, SP3
Any and all info is greatly appreciated.
Thanks,
Jeff Heather
Network Technology Specialist
International Data Group
|