How to realize database backup and recovery through query analyzer in sql server

This article will explain in detail how to achieve database backup and recovery through query analyzer in sql server. The content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Backup and recovery of sql server (query Analyzer) query Analyzer: commands:

1: backup database command: backup database whdb1 (name of database to be backed up) to disk='d:/zwh.bak'

2: restore database command: restore database whdb1 (database name to be restored) from disk='d:/zwh.bak'

3: command for backing up tables: select * into share_20090605 (data backed up) from share (table name)

How to achieve database backup and recovery through query analyzer in sql server is shared here. I hope the above content can be helpful to everyone and learn more knowledge. If you think the article is good, you can share it for more people to see.