Microsoft SQL Database Server is a database engine which should be up and running in order for the Projetex database to function. Though in some cases you may need to stop the Microsoft SQL Server temporarily.
You can start/stop the Microsoft SQL Database Server from the Database Server tab of the Projetex Server Administrator.
When Database Server is stopped, database operations are not accessible. No Projetex Workstations can connect to the database, and the set of Projetex System Administrator features is limited to the Database Server tab.
Stopping the Server
The following procedures may require stopping Microsoft SQL Server.
Manual backup. When the Microsoft SQL Database Server is stopped, it is safe to copy the projetex3D.mdf database file to another location by means of Windows® Explorer. Resort to this kind of backup only in cases when regular the backup does not work for some reason. In all other cases, the regular Backup command does its job well, without need to switch the database into offline mode or stop the Database Server.
Manual restore. When the server is stopped, it is safe to place a projetex3D.mdf stopped-server backup file you have made before into its original location (C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.P3D\MSSQL\DATA).
Moving the current database away before running a regular restore.
Upgrading the Microsoft SQL Database Server software. You will be notified when this upgrade would be recommended.
Note: Stopping the Microsoft SQL Database Server is a critical operation, which can result in data loss if some users are connected to the server. Always switch the database into offline mode (it can be done from the Database tab of the Server Administrator) to ensure no Projetex Workstations are connected to the Database Server before running the Stop Server command.
Note: It is not recommended to install newer versions of the Microsoft SQL Database Server unless there is an explicit recommendation to do this from Projetex Support. We will thoroughly test all future versions of Microsoft SQL, their proper functioning with Projetex Server and Workstation software, and will consider all pros and cons before recommending upgrades. Voluntary upgrades may cause unstable operation of Projetex.
See also: