====== Backup ====== BACKUP DATABASE [WebDashboard] TO DISK = N'D:\MSSQL11.MSSQLSERVER\MSSQL\Backup\GS54SLWI168\WebDashboard\FULL\GS54SLWI168_WebDashboard_FULL_20170608_1200.bak' WITH NOFORMAT, NOINIT, NAME = N'WebDashboard-Complète Base de données Sauvegarde', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10 BACKUP DATABASE [sentinel] TO DISK = N'D:\MSSQL11.MSSQLSERVER\MSSQL\Backup\GS54SLWI168\sentinel\FULL\GS54SLWI168_sentinel_FULL_20170608_1200.bak' WITH NOFORMAT, NOINIT, NAME = N'sentinel-Complète Base de données Sauvegarde', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10 ====== Restore ====== On SQL Server Management Studio: - Right click Databases on left pane (Object Explorer) - Click Restore Database... - Choose Device, click ..., and add your .bak file - Click OK, then OK again