Detach the INOW Database - Detach the INOW Database - Perceptive Content - Moving INOW Database from SQL Server to another SQL Server Machine - Perceptive-Content/Moving-INOW-Database-from-SQL-Server-to-another-SQL-Server-Machine/Foundation-26.1/Moving-INOW-Database-from-SQL-Server-to-another-SQL-Server-Machine-Best-Practices/Moving-the-INOW-Database-from-SQL-Server-to-Another-SQL-Server-Machine/Prepare-to-Move-the-Database/Detach-the-INOW-Database - Foundation 26.1 - Foundation 26.1

Moving INOW Database from SQL Server to another SQL Server Machine Best Practices
Platform
Perceptive Content
Product
Moving INOW Database from SQL Server to another SQL Server Machine
Release
Foundation 26.1
License
ft:lastPublication
2026-04-16T22:17:28.701022
ft:locale
en-US

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.