sql server 数据库不常用操作

1. 数据库存储路径更改第一步：先确认数据库的物理文件位置-- 查看 ReportServer 数据库的物理文件路径USE ReportServer;GOSELECT name AS 逻辑名称, type_desc AS 文件类型, physical_name AS 物理路径, state_desc AS 状态, size * 8.0 / 1024 AS 大小MBFROM sys.database_files;第二步：用 T-SQL 改路径 + 数据库脱机-- 1. 把数据库设为脱机ALTER DATABASE [ReportServer] SET OFFLINE WITH ROLLBACK IMMEDIATE;GO-- 2. 逐个文件改路径（只改路径，不移动文件）-- 根据第二步查到的实际逻辑名称替换ALTER DATABASE [ReportServer] MODIFY FILE (NAME = N' ReportServer ', FILENAME = N'D:\SQLData\ ReportServer.mdf');ALTER DATABASE [REPORTS] MODIFY FILE (NAME = N' ReportServer _log', FILENAME = N'D:\SQLLog\ ReportServer _log.ldf');GO注：NAME是第1步查到的逻辑名称，FILENAME是