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