Backup and recovery for SQL Server

SQL Server of backup and recovery

SQL Server:
Backup command:
BackupDatabase Test
to disk = ' C:\Test '
With FORMAT,
NAME = ' Full Backup of MyNwind '
The explanations are as follows:
NAME = ' Full Backup of MyNwind '-this is the remark, write it casually.
Restore command:
Use master
GO
RESTORE DATABASE TEST_WT
From disk = ' C:\TEST_WT '
GO
Mysql:
Backups: Backup Database dbname to disk= ';d: \dbn.aa ';
Restore: Restore Database dbname from disk= ';d: \dbn.aa ';

Note: 1. Under win, the path with Path/filename.sql is not possible, then use Path\filename.sql

2. Recovery must operate in single-user mode to succeed, we need to disconnect other users and switch to a different database to succeed

Backup and recovery for SQL Server