You can send the following request to your IT department if your company hosts your database. Your IT department should know if they self-host the database. Alternatively, your database may be hosted on Guideware’s or Inspection Logic’s (SkyBridge) servers, in which case you will have to request a backup of your database from their support teams.
| Email Template |
|---|
| I would like to request a backup for the following SQL database, in the form of a .bak file: • Site Name: [Your Site name] • Database Name: [Your Database Name] Thank you. [Your Name] |
Inspection Logic or Guideware’s support team will provide you a link to download the backup. Please forward this to LDARtools. If your IT department is the one who created the backup, LDARtools can provide a link for them to upload the backup file if they do not have a preferred file share software.
If, for some reason, you have access to the server and there is no IT department, then you can follow the steps below to create a backup of your database to send to LDARtools. LDARtools will provide an upload link when needed.
A .bak file contains a full backup of your database. This guide will walk you through the process of generating a .bak file using SQL Server Management Studio (SSMS).
-
Open SQL Server Management Studio (SSMS).
a. Open SQL Server Management Studio on your computer.
b. Connect to Your Database.
- In the “Connect to Server” window, enter the server name and authentication details to connect to the SQL Server instance containing the database you want to back up.
- In the “Connect to Server” window, enter the server name and authentication details to connect to the SQL Server instance containing the database you want to back up.
-
Select the database.
a. Expand Server Node.
- In the Object Explorer, expand the server node to view the databases.
b. Locate and right-click the database you want to back up.
- In the Object Explorer, expand the server node to view the databases.
-
Initiate the backup process.
a. Select the backup option.
- From the right-click menu, navigate to Tasks > Back Up.
b. Configure backup settings.
-
In the Back Up Database window, ensure the database name is correct.
-
Set the “Backup type” to Full to create a full backup of the database.
- From the right-click menu, navigate to Tasks > Back Up.
-
Specify the backup destination.
a. Select destination.
-
Under the “Destination” section, ensure the Disk option is selected.
-
Click Add… to specify the file location where the backup will be saved.
b. Choose backup file location.
-
In the Select Backup Destination window, click the … button to browse and select the directory.
-
Enter the file name with a .bak extension (e.g., DatabaseName_FullBackup.bak) and click OK.
c. Confirm the destination.
- Verify the selected destination path is listed correctly and click OK to close the Select Backup Destination window.
-
-
Perform the backup.
a. Initiate backup.
-
Review all the settings in the Back Up Database window to ensure they are correct.
-
Click OK to start the backup process.
b. Monitor progress.
- A progress window will appear indicating the status of the backup. Wait for the backup to complete.
c. Completion confirmation.
- Once the backup completes, a confirmation message will appear. Click OK to close the message.
-
-
Verify the backup file.
a. Locate the backup file.
- Navigate to the directory where you saved the .bak file to ensure it was created successfully.
- Navigate to the directory where you saved the .bak file to ensure it was created successfully.
-
Upload the backup file to the ShareFile upload link provided by LDARtools.