USE [master];
GO

RESTORE FILELISTONLY
FROM DISK = 'E:\SqlServer\最新數據庫\GLASS_2024-03-02.bak' --查詢bak備份信息

--關閉鏈接
ALTER DATABASE [GLASS]
SET OFFLINE WITH ROLLBACK IMMEDIATE

RESTORE DATABASE GLASS --還原到數據庫
FROM DISK = 'E:\SqlServer\最新數據庫\GLASS_2024-03-02.bak'
WITH replace, --替換
RECOVERY, --恢復
MOVE 'GLASS' TO 'E:\SqlServer\MSSQL16.SQLEXPRESS\MSSQL\DATA\GLASS.mdf', --設置新的數據庫文件
MOVE 'GLASS_log' TO 'E:\SqlServer\MSSQL16.SQLEXPRESS\MSSQL\DATA\GLASS_log.ldf'; --設置新的日志文件
GO