Restoring an SQL dabatase for BMD NTCS

16.07.2020 | NTCS Dokumentationen

1. Restoring an SQL database

This guide is for skilled computer administrators with experience in working with databases. It is intended to help you with restoring a database. However, this guide is in no way a basis for claims in case of data loss. The customer is solely responsible for ensuring a full, correct and restorable backup of all data.

1.1. Recovery of a database

Prerequisite for recovering a database is that you have configured an SQL backup as explained in “Setting up an SQL backup for BMD NTCS” and that it works.

1.1.1. Restoring backup to a second database

First, you have to create a directory, to which the database will be restored. In this example we use the path C:\BMDDataBaseRESTORE.

Windows 7 / server 2008 R2 or earlier versions:

Start → Programs → Microsoft SQL Server 20xx → start SQL Server Management Studio.

Windows 8 / server 2012 or later versions:

Enter ‘SQL Server Management Studio’ in the search dialogue of the Metro user interface or use the arrow buttons to search the entry and start it.

Alternatively, you can find the program in Windows Explorer under the following path:

„C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 20xx“

Replace “20xx” with the respective SQL version in use.

CAUTION!
If Windows User Account Control (UAC) is active, you have to start SQL Server Management Studio by right-clicking and selecting ‘Run as administrator’!

In SQL Management Studio → right-click on ‘Databases’ → Restore Database…

Select ‘Device’ and click on the ellipses button for more options.

Under ‘Backup media type’ select ‘Backup device’, click on ‘Add’ and select ‘Backup-BMD’ as your backup device.

Alternatively, you have the option to enter the backup file instead of the backup device in ‘Backup media type’.

1.1.2. Settings

Enter the name of the new database (BMDRESTORE) and select which backup sets are to be restored. Under ‘Backup Timeline’ you can even select to restore the backup to a specific point in time.

In ‘Files’, the next tab of the menu, you now have to define the new path for restoring the database. In this case we relocate the database files from “C:\BMDDataBase” to “C:\BMDDataBaseRESTORE”. In SQL 2012 or later versions you can simply use the option ‘Relocate all files to folder’.

Under ‘Options’ you then have to make sure that ‘Take tail-log backup before restore’ and ‘Leave source database in the restoring state’ are not enabled:

1.1.3. Starting restoring the database

You can now start to restore the database by clicking ‘OK’.

If everything was set up correctly, you will see a progress bar in the upper right corner.

Once recovery of the database is complete, you should receive the following notification:

1.1.4. ALIAS name and login

Now you have to add the ALIAS name. To do so, start the program \BMDsoftware\BMDDBUpdate.exe and click on the icon next to the database name. Add the new database and confirm with ‘Accept’.