当直接还原不成功时,可以用语句来还原:
RESTORE DATABASE PingshanDb
FROM DISK = 'E:\Program Files\java\sql\PingshanDb.bak' --bak文件路径with replace,
MOVE 'PingshanDb' TO 'E:\Program Files\Microsoft SQL Server\Gen\MSSQL12.MSSQLSERVER\MSSQL\DATA\PingshanDb.mdf', --mdf文件路径
MOVE 'PingshanDb_log' TO 'E:\Program Files\Microsoft SQL Server\Gen\MSSQL12.MSSQLSERVER\MSSQL\DATA\PingshanDb.ldf' --ldf文件路径