1.查看当前的存放路径:
select database_id,name,physical_name AS CurrentLocation,state_desc,size from sys.master_files
where database_id=db_id(N'ComDataCenter');
2.修改存放路径,这里的数据库为:ComDataCenter
alter database ComDataCenter modify file ( name = ComDataCenter, filename = 'G:\SQL_SERVER_DATA\comdatacenter');
alter database ComDataCenter modify file ( name = ComDataCenter_log, filename = 'G:\SQL_SERVER_DATA\comdatacenter');
3.重启数据库即可。
2.修改存放路径,这里的数据库为:ComDataCenter
alter database ComDataCenter modify file ( name = ComDataCenter, filename = 'G:\SQL_SERVER_DATA\comdatacenter');
alter database ComDataCenter modify file ( name = ComDataCenter_log, filename = 'G:\SQL_SERVER_DATA\comdatacenter');
3.重启数据库即可。