Copy and Attach the INOW Database Files to the New Location - Moving INOW Database from SQL Server to another SQL Server Machine - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content

We recommend copying files instead of moving so that you can successfully retain the original files. The following steps explain how to copy the files that you have identified in the Identify the INOW Database Files in an earlier section of this document.

To copy the files, complete the following steps.

Copy all the INOW database files manually at a new location.
Adjust the file path for each FILENAME to reflect the respective current location.
If you have added files to your database, add those additional files to the following command.
The list of files that were displayed when you performed the query to identify database files should be copied to the new location and included in the command.
In SQL Server Management Studio, on the toolbar, click New Query.
Copy and paste the following command set in the Query tab.

USE master 
GO 
CREATE DATABASE INOW ON 
( FILENAME = N'E:\MSSQL\DATA\INOW.mdf' ), 
( FILENAME = N'E:\MSSQL\DATA\INOW.ldf' ), 
( FILENAME = N'E:\MSSQL\DATA\INOW.ndf' ) 
FOR ATTACH 
 GO

On the toolbar, click Execute.
To view the newly attached INOW database in the list, refresh the list of databases.