Starting a database without connecting (SQL)

You can start a database without connecting to it by using the START DATABASE statement.

Prerequisites

By default, you must have the SERVER OPERATOR system privilege. The required privileges can be changed by using the -gd database server option.

Results

The database is started.

Example

Start the database file c:\temp\temp.db on the current database server.

START DATABASE 'c:\\temp\\temp.db'
AS tempdb 
AUTOSTOP OFF;

The AUTOSTOP OFF connection parameter prevents the database from being stopped automatically when all connections have been disconnected.