一.查看:
restore filelistonly from disk='F:DbA_backup.bak'
二.还原:
RESTORE DATABASE A
FROM DISK = 'F:DbA_backup.bak' --bak文件路径
with replace,
MOVE 'A' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAA.mdf', --mdf文件路径
MOVE 'A_log' TO 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAA_log.ldf' --ldf文件路径