BACKUP DATABASE 1

[password99]

When you backup to the same file as your previous backup file, how does SQL Server know what data needs to be restored if you restore the previous backup (altough stored in the same file).

 

[JayKusch]

If you backed up to the previous file, you no longer can restore that file.

Thanks

J. Kusch

 

[password99]

I thought that too

But, Here is what I did

backup DB to file1 (named A)
change data
backup DB to file1 (named B)

Perform Restore DB from Enterprise
Selected named A
It restored data before to original (same as when I backed up named A)

I was wondering how you can do this with Transact SQL

 

[SQLBill]

Refer to the Books OnLine. Use the Index tab and enter RESTORE DATABASE. Scroll down to the option for Transact-SQL and display that.

Look for the FILE option.

You can use FILE to tell the RESTORE which part of the backup to use.

-SQLBill

 

[password99]

is value in the FILE option same as backupset.position column value?

 

[password99]

If you select Full Recovery option using 'BACKUP DATABASE' does it automatically truncate the Log file after each backup operataion?