On Mon, 13 Jun 2005, Phil Gaitan wrote:

PG> I've got a question on how Legato backs up MSSQL databases.  It was
PG> always my understanding that Legato did 'row by row' differentials so
PG> that only pages that changed were backed up on a 'diff' and not the
PG> whole database.  I'm having an issue were one of my customer's databases
PG> appears to be getting a 'full' every night even though Legato shows it
PG> as a diff.
PG> 
PG> Does Legato backup the whole database if a cell has changed, or is it a
PG> row or even a table?  According to Legato's MSSQL manual it says:
PG> 
PG> Select one or more databases to create a database level differential
PG> backup of only the changes made to the selected
PG> databases since the last full level backup was created.
PG> 
PG> I don't know if this means the entire DB gets backed up, or just a row
PG> etc..

I'm not THE expert on this subject, but as far as I understand it, 
networker will use the MSSQL backup API to do backups. I'm not sure if 
Networker can do what you describe for you, but we do full and incr 
backups. The incr backups back up the transaction logs for the database in 
question. This requires the database setting "Recovery mode" to be set to 
"full". Otherwise, there won't be any complete transaction logs, and in 
order to accomplish usable backups, networker automatically reverts to 
level full, at least if you use "simple" as the recovery model.

//Oscar

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