Backing up your BrDR database
- Mark Mlynarski, P.E.
Date | July, 2022 |
Product | AASHTOWare BrDR |
Version | All |
Description | Backing up and AASHTOWare database |
How do I backup my BrDR database?
This article covers the following topics:
Backing up a SQL database
Reference for more information
The following partial description was taken from the following link on the Microsoft:
Create a Full Database Backup - SQL Server | Microsoft Docs
It describes the general procedure for backing up an SQL Server database.
For further information, click the link above.
A. Full back up to disk to default location
In this example, the SQLTestDB database will be backed up to disk at the default backup location.
After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, expand the server tree.
Expand Databases, right-click SQLTestDB, point to Tasks, and then select Back Up....
Select OK.
When the backup completes successfully, select OK to close the SQL Server Management Studio dialog box.
B. Full back up to disk to non-default location
In this example, the SQLTestDB database will be backed up to disk at a location of your choice.
After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, expand the server tree.
Expand Databases, right-click SQLTestDB, point to Tasks, and then select Back Up....
On the General page in the Destination section select Disk from the Back up to: drop-down list.
Select Remove until all existing backup files have been removed.
Select Add and the Select Backup Destination dialog box will open.
Enter a valid path and file name in the File name text box and use .bak as the extension to simplify the classification of this file.
Select OK and then select OK again to start the backup.
When the backup completes successfully, select OK to close the SQL Server Management Studio dialog box.
