How to Backup via SQL Server Management Studio

Overview:

Backing up your QNE Optimum database through SQL Server Management Studio (SSMS) offers a reliable and manual method for safeguarding your financial data. This process is especially helpful during system maintenance, before software upgrades, or when the in-app backup feature is unavailable due to issues such as a “Backup Failed” error.

Scenario:

You are preparing to upgrade QNE Optimum or perform system maintenance and want to ensure your company’s accounting data is securely backed up. The built-in QNE backup utility is currently not accessible, so you opt to manually perform a database backup using SQL Server Management Studio.

Procedure:

Step 1: Launch SQL Server Management Studio.

• Open SQL Server Management Studio and connect to your QNE Optimum SQL Server instance.
  
  

Step 2: Access the Database and Initiate Backup

• Expand the Databases folder.

• Locate and right-click the relevant QNE database (e.g., 2021101).

• Go to Tasks > Back Up...
  

Step 3: Set the Backup Destination

• In the Back Up Database window, the default backup path is usually: C:\Program Files\Microsoft SQL Server\MSSQL11.QNEBSS\MSSQL\Backup\

• To change Folder Location click Remove to delete the current path.
  

• Click Add > select the ellipsis (...) to browse.
  

• Choose the desired folder, enter a file name with .bak extension, then click OK.
  

•  On the Select Backup Destination window showing the new path, click OK again to confirm.
  

Step 4: Start the Backup

• After confirming the backup path and file name, click OK to initiate the backup process.
  

Step 5: Confirmation

• Once the process completes, a message will appear indicating that the backup was successful: “The backup of database '2021101' completed successfully.”
  

Application:

The database backup is now securely stored and ready for future use, such as restoration or migration.