O'Reilly logo

Getting Started with SQL Server 2014 Administration by Gethyn Ellis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using delayed transaction durability

You, as the database administrator, can control Delayed Durability at the database level and can set it using an ALTER database statement as follows:

USE [master]
GO
ALTER DATABASE [DB1] SET DELAYED_DURABILITY = ALLOWED WITH NO_WAIT
GO

This code changes the database option for Delayed Durability on the DB1 database from Disabled to Allowed.

You can also set this using Management Studio. Right-click on the database whose Delayed Durability settings need to be changed, and choose Properties, and then choose the Options page. You will see a list of options; scroll down until you come to the Delayed Durability option. There you will find a drop-down list with three options: Disabled, Allowed, and Forced. Choose the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required