1.查看当前的存放路径：
select database_id,name,physical_name AS CurrentLocation,state_desc,size from sys.master_files where database_id=db_id(N'AnyOffice');
2.停服务，停库
拷贝AnyOffice.mdf、AnyOffice_log.ldf到E:\SQL_SERVER_DATA\datacenter\
3.修改存放路径，这里的数据库为：AnyOffice
alter database AnyOffice modify file ( name = Recovered_AnyOffice, filename = 'E:\SQL_SERVER_DATA\datacenter\AnyOffice.mdf');
alter database AnyOffice modify file ( name = Recovered_AnyOffice_log, filename =
'E:\SQL_SERVER_DATA\datacenter\AnyOffice_log.ldf');
4.重启数据库.
select database_id,name,physical_name AS CurrentLocation,state_desc,size from sys.master_files where database_id=db_id(N'AnyOffice');
2.停服务，停库
拷贝AnyOffice.mdf、AnyOffice_log.ldf到E:\SQL_SERVER_DATA\datacenter\
3.修改存放路径，这里的数据库为：AnyOffice
alter database AnyOffice modify file ( name = Recovered_AnyOffice, filename = 'E:\SQL_SERVER_DATA\datacenter\AnyOffice.mdf');
alter database AnyOffice modify file ( name = Recovered_AnyOffice_log, filename =
'E:\SQL_SERVER_DATA\datacenter\AnyOffice_log.ldf');
4.重启数据库.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29362142/viewspace-2139619/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
merge 简单测试
请登录后发表评论
登录
全部评论
