User Tools

Site Tools


database:sqlserver:backup-restore

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:

  1. Right click Databases on left pane (Object Explorer)
  2. Click Restore Database…
  3. Choose Device, click …, and add your .bak file
  4. Click OK, then OK again
database/sqlserver/backup-restore.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1