详细问题不在阐述,遇到了数据库将C盘撑爆的情况.
我的问题帖子:http://bbs.csdn.net/topics/390777927?page=1#post-397330194
参考帖子:http://blog.csdn.net/kelat/article/details/8599488
解决方案:
--1确定数据库当前位置。SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('distribution');
GO
--2迁移
USE master;
GO
ALTER DATABASE distribution
MODIFY FILE (NAME = distribution, FILENAME = 'D:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\distribution.MDF');
GO
ALTER DATABASE distribution
MODIFY FILE (NAME = distribution_log, FILENAME = 'D:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\distribution.LDF');
GO
--2迁移
--3停止并重新启动 SQL Server
--4验证更改。
SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('distribution');