Backup Types and Options
Posted on 2011-04-29
Bear with me since I am new to SQL Server. I have previously worked with Oracle.
I was taking some backups of different databases on my server. These include the System Databases, Master, MSDB, Model and so on.
I was wondering, why do some user databases only give me the option to do Full and Differential Backups, while others, allow me to do Full, Differential and Transaction Log backups. Can anyone explain why this is?
I thought at first it might be the Recovery Option for the paticular databases, but it turns out that some of the user databases that have their recovery option set to simple, will allow any type of backup, whereas others only allow the Full and Differential options. Can anyone explain how these options are determined.