sql server 数据库恢复语句

利用bak恢复数据库，强制还原(REPLACE)
STATS = 10 每完成10%显示一条记录

restore database AIS20181207174817_zhengshi

from disk = 'F:\SoftWare\K3Cloud\AIS20181207174817_zhengshi_backup_2022_06_22_123000_8598426.bak'

with move 'SqlServer_BC_20120727194252_Data' to 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AIS20181207174817_zhengshi_Data.mdf',

move 'SqlServer_BC_20120727194252_Log' to 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AIS20181207174817_zhengshi_log.ldf',

STATS = 10, REPLACE;