SQL Server supports three recovery models: Simple, Bulk-Logged, and Full. The Simple model does not support transaction log backups and is suitable for scenarios where data loss is acceptable.

SQL Server Management Studio (SSMS) is a graphical interface that simplifies the management of your SQL Server environment, including transaction log backups. To create a log backup using SSMS ...

When you finish the restore operation and recover the database, the recovery process is executed to ensure the integrity of the database. For more information about the recovery process, see Restore ...

Learn how to view the data and log files in a backup set in SQL Server by using SQL Server Management Studio or Transact-SQL. In [!INCLUDEsql2008-md] and later versions, obtaining information about a ...

In this article, we’ve discussed different types of backups in SQL Server and how to create these backups. We also discussed the ways to restore database backups using SSMS and T-SQL commands. In case ...

Last time, we discussed the different backup types available in SQL Server. Now, let's take a quick look at some best practices when it comes to configuring those backups. Although there is no one set ...

Idera’s SQLsafe — a backup utility for Microsoft SQL Server — was designed to compete directly with Imceda’s LiteSpeed. Similar to LiteSpeed, SQLsafe improves on native SQL Server backups ...

This article is a revised version of the original published January 3, 2005. See Editor’s Note for details. Two major factors drive database backups these days: compliance and disk space. Some ...

In an earlier blog entry, I talked about “Deprecated” code and I highlighted the fact that the BACKUP LOG WITH NO_LOG and BACKUP LOG WITH TRUNCATE_ONLY statements are no longer allowed in SQL ...