sqlserver备份bak文件恢复数据库

避免版本软件冲突，直接使用sql恢复

USE master;
GO
 
-- 检查目标数据库是否存在，如果存在则删除
IF EXISTS (SELECT name FROM sys.databases WHERE name = 'YourDatabaseName')
BEGIN
    DROP DATABASE YourDatabaseName;
END
GO
 
-- 还原数据库
RESTORE DATABASE YourDatabaseName
FROM DISK = 'C:\path\to\your\backupfile.bak'
WITH MOVE 'YourDatabaseName_Data' TO 'C:\path\to\your\database\YourDatabaseName_Data.mdf',
     MOVE 'YourDatabaseName_Log' TO 'C:\path\to\your\database\YourDatabaseName_Log.ldf',
     STATS = 5, REPLACE;
GO