Bringing Offline Pages Online

Use sp_forceonline_db to make all the offline pages in a database accessible, and use sp_forceonline_page to make an individual offline page accessible.

Specify the type of access with both of these procedures.

You cannot execute sp_forceonline_db or sp_forceonline_page inside a transaction.

You must have the sa_role and be in the master database to execute sp_forceonline_db and sp_forceonline_page.

See the Reference Manual: Procedures.