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.

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.

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

There is a quiet revolution brewing in the backup and recovery arena that will have a profound effect on how IT departments configure their SQL Server 2000 databases. I use the word quiet because ...