Sie sehen die Flagge von Österreich

BMD
Österreich

Sie sehen die Flagge von Deutschland

BMD
Deutschland

Sie sehen die Flagge der Schweiz

BMD
Schweiz

Sie sehen die Flagge von Ungarn

BMD
Magyarország

Sie sehen die Flagge der Slowakei

BMD
Slovensko

Sie sehen die Flagge von Tschechien

BMD
Česko

Sie sehen die englische Flagge

BMD
International

Sie sehen die Flagge der Slowakei SK
Vyhľadaj

Restoring an SQL dabatase for BMD NTCS

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’.

 

Then you have to set ‘Login mode’ to ‘WindowsLogin’. By clicking ‘Login’ you start the program.

 

When the following window appears exit the program by clicking ‘Close’:

 

Now you can log in to the restored database:

 

Section:

NTCS Documentation




BMD Business Solutions s.r.o.

Nám. 1. mája 7991/9

SK-81106 Bratislava - Staré Mesto

+421 220 861 990

bratislava@bmd.com

Partner
Partner SKDP

Follow us

Folgen Sie uns auf LinkedIn
Folgen Sie uns auf YouTube