06-06-2014 03:00 AM
Hi
in case of MS SQL backups FULL DIFFRENTIAL means all the changes since last full backup(equivalent to cummulative incr), is it possible to take incr backup of databases as object ?
Also if recovery mode is simple then incremental backups will truncate the logs automatically or does it happens only in case of full backups.?
Solved! Go to Solution.
06-06-2014 03:31 AM
A transaction log backup is the same as an incremental backup as the changes are what is in the trx logs.
The database needs to be in Full or BulkLogged do back it up in that way
Work through the NBU SQL Admin guide for full details
06-10-2014 12:42 AM
I got to know if DB is in simple recovery mode, then only Full & full differential backups are possible.
Transactions Logs backup is not possible in Simple recovery mode of DB, so if I am not wrong then FULL PARTIAL backup also truncates the logs.
06-06-2014 03:31 AM
A transaction log backup is the same as an incremental backup as the changes are what is in the trx logs.
The database needs to be in Full or BulkLogged do back it up in that way
Work through the NBU SQL Admin guide for full details
06-10-2014 12:42 AM
I got to know if DB is in simple recovery mode, then only Full & full differential backups are possible.
Transactions Logs backup is not possible in Simple recovery mode of DB, so if I am not wrong then FULL PARTIAL backup also truncates the logs.