Before starting, save a backup to prevent any data loss. If you have any questions regarding computer and database administration, contact the necessary personnel.
 
Please make sure all across services are stopped and the server application crossAdmin is closed. If using Personal Edition, simply close across. 

Note: Microsoft SQL Server 2019 is the latest version. See the following link for more information on installing SQL Server 2019.

  

  

Detach Database


1. Go to Start > Programs > SQL Server 2019 > SQL Server Management Studio (Express) and open the application. 
 
2. When the application opens, connect to the database engine or SQL Server. Enter the correct SQL Server name and the possible instance name as shown below. 

 

Note: in the case of Personal Edition, databases are always created in an instance which is named "across." The SQL Server name is your computer name. 
 
Connect with Windows Authentication. (You should have Windows administration rights.)




2. Connect with SQL Server Authentication. If you have no Windows administration rights, but you know the password for the SQL Server administration ("sa"). When using Personal Edition this password is set automatically during installation, which is "sa123456"



3. After successful connection, expand the folder named, "Databases" in the object explorer, right-click the database you want to detach and select Tasks > Detach. The below example uses the database called, "ManexTest."
  
  
A new window will open, but leave it as is, and click "OK" to detach the database.

 
  
4. After successful detachment, the window automatically closes and the database is no longer listed on the Object Explorer. If you want to move all across databases, detach cTank and cTerm databases. After detachment of all databases, there should be no databases listed on the Object Explorer. 
   
Attach Database
 
1. Find the detached databases and database log files by default under: C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Data and move the files to the new destination. If you have detached all three databases, you have to move six files (three databases and three database log files). 


2. After moving the databases, go back to the SQL Server Management Studio Object Explorer and right-click the folder databases, and select "Attach."

  

 

A new window will open, then press '"Add."
 
  
  
3. Another new window will open. Browse and locate where your databases are stored (they may be stored in the Microsoft SQL Setup folder). Next, select and add your databases (only the databases).

   
    
4. When you have added the databases, the window should look like the screenshot below. Please check the file location and file names to make sure they are correct, and click "OK" to attach these databases.
 
   
   
The databases should be attached, as seen in the example below.
 

 
5. Lastly, reopen the server application crossAdmin and start all across services again. In using Personal Edition, open across.

  

  

For more information on attaching and detaching databases, see the following article from Microsoft: Database Detach and Attach (SQL Server).