Starting a database without connecting (SQL)

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

Prérequis

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

Résultat

The database is started.

Exemple

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.