SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

Change the Configuration Settings for a Database

SQL Server 2012

This topic describes how to change database-level options in SQL Server 2012 by using SQL Server Management Studio or Transact-SQL. These options are unique to each database and do not affect other databases.

In This Topic

Limitations and Restrictions

  • Only the system administrator, database owner, members of the sysadmin and dbcreator fixed server roles and db_owner fixed database roles can modify these options.

Security

Permissions

Requires ALTER permission on the database.

Arrow icon used with Back to Top link [Top]

To change the option settings for a database

  1. In Object Explorer, connect to a Database Engine instance, expand the server, expand Databases, right-click a database, and then click Properties.

  2. In the Database Properties dialog box, click Options to access most of the configuration settings. File and filegroup configurations, mirroring and log shipping are on their respective pages.

Arrow icon used with Back to Top link [Top]

To change the option settings for a database

  1. Connect to the Database Engine.

  2. From the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute. This example sets the recovery model and data page verification options for the AdventureWorks2012 sample database.

Transact-SQL
Copy 
USE master;
GO
ALTER DATABASE AdventureWorks2012 
SET RECOVERY FULL, PAGE_VERIFY CHECKSUM;
GO

For more examples, see ALTER DATABASE SET Options (Transact-SQL).

Arrow icon used with Back to Top link [Top]

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.