In this tutorial, I will show you how to restore a SQL Server database from a backup file (BAK).
To perform the restore, you must have SQL Server Manager Studio (SSMS).
Restore a database
In order to find the backup files, I copied them to the Backup folder of the SQL Server installation, which is not required. Open SSMS, once connected, right click on Databases 1 and click Restore files and files groups 2 .
Select or enter the name of the database 1 , choose the option From the unit 2 then click on the button Browse 3 to choose the file (s).
Click on Add 1 .
Select the database backup file 1 and click OK 2 .
Validate by clicking OK 1 .
Check the box 1 in the Restore column and click OK 2 to restore the database.
After the database is restored, a confirmation message appears, click OK 1 to close it.
Check that the base is present in list 1 , it may be necessary to update the display to see it.
Introduction In this tutorial, I'll explain how to disable access to previous versions by GPO from client computers. Although convenient, this feature in case of user error can do some damage. As a re
Nous utilisons des cookies pour vous garantir la meilleure expérience sur notre site. Si vous continuez à utiliser ce dernier, nous considérerons que vous acceptez l'utilisation des cookies.OkEn savoir plus