导航

09 2020 档案

always on 下移动数据库文件 AlwaysON move database without breaking HADR

该文被密码保护。

posted @ 2020-09-22 18:44 yiyishuitian 阅读(0) 评论(0) 推荐(0)

SqlServer修改数据库文件存放位置

摘要：1 --查看当前的存放位置 select database_id,name,physical_name AS CurrentLocation,state_desc,size from sys.master_files where database_id=db_id(N'数据库名'); 2 --修改文 阅读全文

posted @ 2020-09-18 10:45 yiyishuitian 阅读(1308) 评论(0) 推荐(0)

always on 下移动数据库文件 AlwaysON move database without breaking HADR

摘要：https://www.sqlservercentral.com/blogs/alwayson-move-database-without-breaking-hadr This post is going to show the database movement from one drive to 阅读全文

posted @ 2020-09-17 08:38 yiyishuitian 阅读(292) 评论(0) 推荐(0)