备份恢复SQL
查看备份内容
RESTORE FILELISTONLY from disk = 'F:\MIP\wipzzbackup.bak'
恢复数据库
restore database AWorkShop from disk = 'F:\MIP\wipzzbackup.bak'
with move 'AWorkShop_Data' to 'F:\MSSQL\Data\AWorkShop.mdf'
,move 'AWorkShop_log' to 'E:\MSSQL\Log\AWorkShop_log.ldf'
RESTORE FILELISTONLY from disk = 'F:\MIP\wipzzbackup.bak'
恢复数据库
restore database AWorkShop from disk = 'F:\MIP\wipzzbackup.bak'
with move 'AWorkShop_Data' to 'F:\MSSQL\Data\AWorkShop.mdf'
,move 'AWorkShop_log' to 'E:\MSSQL\Log\AWorkShop_log.ldf'
