Before you begin backing up a SQL Server database, you need to know which recovery model the database is using. There are three different recovery models: FULL, BULK_LOGGED, and SIMPLE.

Popular Topics Generative AI; Networking; Cloud Computing; Data Center; Search ...

Ok, I know that I'll need to set up Transaction Log backups, but I have two questions on this process: Background: Database is a VMware VM on a SAN, and the MDF is about 15GB. Recovery model is ...

SQL Server 2005 databases are set to the Full recovery model by default, so you may need to start creating log backups even if you haven’t ran into problems yet.

Brian has specialized in Office 365, SharePoint, and SQL Server integration over the past few years, but his breadth of knowledge also includes Microsoft operating systems and Active Directory.