Detach the INOW Database - Moving INOW Database from SQL Server to another SQL Server Machine - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Moving INOW Database from SQL Server to another SQL Server Machine
Platform
Perceptive Content
Product
Moving INOW Database from SQL Server to another SQL Server Machine
Release
Foundation 24.1
License

The following command puts the INOW database in SINGLE_USER mode. When this command is activated the system stops, rolls back, and then disconnects any other connections to the database in order to successfully complete the detach command.

To detach the INOW Database, complete the following command.

  1. In SQL Server Management Studio, on the toolbar, click New Query.
  2. Copy and paste the following command set in the Query tab. 
    USE master 
GO 
ALTER DATABASE INOW SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
GO 

USE master 
GO 

EXEC master.dbo.sp_detach_db @dbname = N'INOW', @skipchecks = 'false' 
GO
  3. On the toolbar, click Execute.