I'm enabling database mirroring on SQL Server 2008 R2, I've already configured my servers but when trying to start mirroring I get the following error:
我在SQL Server 2008 R2上启用数据库镜像,我已经配置了我的服务器,但在尝试启动镜像时出现以下错误:
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'PlaneamientoComercialDB'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
A database cannot be enabled for both FILESTREAM storage and Database Mirroring. (Microsoft SQL Server, Error: 5574)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000&EvtSrc=MSSQLServer&EvtID=5574&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I don't even have files on my database so I'd like to turn off filestream, how can I do it?
我甚至没有我的数据库上的文件,所以我想关闭文件流,我该怎么办?
Thanks
4 个解决方案
#1
2
I ran into this issue when trying to test mirroring between 2 qa servers. Right click database --> Properties --> Filegroups
尝试测试2个qa服务器之间的镜像时遇到了这个问题。右键单击数据库 - >属性 - >文件组
Remove filestream and click ok. Make sure to do on both servers or it will still fail.
删除文件流,然后单击确定。确保在两台服务器上都可以,否则它仍然会失败。
#2
1
FILESTREAM is configured at the server instance level. Use SQL Server Configuration Manager to disable. Under SQL Server Configuration Manager -> SQL Server Services. Find the service, right-click, properties:
FILESTREAM在服务器实例级别配置。使用SQL Server配置管理器禁用。在SQL Server配置管理器 - > SQL Server服务下。找到服务,右键单击,属性:
#3
0
Although I don't have any columns that uses FILESTREAM, for some reason I had a filegroup containing filestream. I could solve the issue by removing the filegroup
虽然我没有任何使用FILESTREAM的列,但由于某种原因,我有一个包含文件流的文件组。我可以通过删除文件组来解决问题
ALTER DATABASE MyDBName
REMOVE FILEGROUP MyFileGroupName
Thanks
#4
0
Database Mirroring and FILESTREAM data not allowed
不允许使用数据库镜像和FILESTREAM数据
Just to verify, I tested out Database Mirroring with the full version of AdventureWorks2008 and, although it let me setup the Mirroring endpoints, it did not allow Mirroring to start giving an error 5574: “A database cannot be enabled for both FILESTREAM storage and Database Mirroring”.
为了验证,我使用完整版的AdventureWorks2008测试了数据库镜像,虽然它允许我设置镜像端点,但它不允许镜像开始给出错误5574:“无法为FILESTREAM存储和数据库启用数据库镜像”。
#1
2
I ran into this issue when trying to test mirroring between 2 qa servers. Right click database --> Properties --> Filegroups
尝试测试2个qa服务器之间的镜像时遇到了这个问题。右键单击数据库 - >属性 - >文件组
Remove filestream and click ok. Make sure to do on both servers or it will still fail.
删除文件流,然后单击确定。确保在两台服务器上都可以,否则它仍然会失败。
#2
1
FILESTREAM is configured at the server instance level. Use SQL Server Configuration Manager to disable. Under SQL Server Configuration Manager -> SQL Server Services. Find the service, right-click, properties:
FILESTREAM在服务器实例级别配置。使用SQL Server配置管理器禁用。在SQL Server配置管理器 - > SQL Server服务下。找到服务,右键单击,属性:
#3
0
Although I don't have any columns that uses FILESTREAM, for some reason I had a filegroup containing filestream. I could solve the issue by removing the filegroup
虽然我没有任何使用FILESTREAM的列,但由于某种原因,我有一个包含文件流的文件组。我可以通过删除文件组来解决问题
ALTER DATABASE MyDBName
REMOVE FILEGROUP MyFileGroupName
Thanks
#4
0
Database Mirroring and FILESTREAM data not allowed
不允许使用数据库镜像和FILESTREAM数据
Just to verify, I tested out Database Mirroring with the full version of AdventureWorks2008 and, although it let me setup the Mirroring endpoints, it did not allow Mirroring to start giving an error 5574: “A database cannot be enabled for both FILESTREAM storage and Database Mirroring”.
为了验证,我使用完整版的AdventureWorks2008测试了数据库镜像,虽然它允许我设置镜像端点,但它不允许镜像开始给出错误5574:“无法为FILESTREAM存储和数据库启用数据库镜像”。