The following command lists all of the files associated with the INOW database. The following steps explain how to identify the database files.
- In SQL Server Management Studio, on the toolbar, click New Query.
- In the Query tab, copy and paste the following command.
USE INOW GO select name,physical_name from sys.database_files;
- On the toolbar, click Execute.
- In the Results tab, note the file names and locations so you can manually copy the files to a new location. Refer to the Copy and attach the INOW database files to the new location section for additional information about copying the files.