Share database backup and recovery methods using the query analyzer in sqlserver

Share the database backup and recovery methods using the query analyzer in sqlserver. If you need to back up or restore the database, refer

Share the database backup and recovery methods through the query analyzer in SQL server. If you need to back up or restore the database, refer

SQL server backup and recovery (query analyzer)

Query Analyzer:
Command:
1: backup database command:
Backup database whdb1 (name of the database to be backed up) to disk = 'd:/zwh. bak ';

2: database recovery command:
Restore database whdb1 (name of the database to be restored) from disk = 'd:/zwh. bak ';

3: Backup table command:

Select * into partition _20090605 (backup data) from share (Table Name );

Author Zhuang Weihong