SQL Server database backup and Restoration

& Nbsp; posting path: blog. csdn. netzjcxcarchive2003122920074.aspx uses the T-SQL statement to realize the function of database backup and restoration, which reflects the four knowledge points in SQLServer: 1. & nbsp; obtain the default directory 2 on the SQLServer server. & nbsp; use of backup SQL statement 3. & nbsp

Paste path: http://blog.csdn.net/zjcxc/archive/2003/12/29/20074.aspx

The T-SQL statement is used to realize the function of database backup and restoration, which reflects the four knowledge points in SQL Server:

1. Obtain the default directory on the SQL Server

2. Use of backup SQL statements

3. Restore the use of SQL statements, and disable the processing of other user processes during forced recovery.

4. Use of SQL statements for job creation

<