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博客 ” ,链接:http://blog.itpub.net/29362142/viewspace-2139619/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29362142/viewspace-2139619/