如何在SQL Server 2008 R2上禁用Filestream以启用镜像?

时间:2021-05-31 03:54:12

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服务下。找到服务,右键单击,属性:

如何在SQL Server 2008 R2上禁用Filestream以启用镜像?

#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服务下。找到服务,右键单击,属性:

如何在SQL Server 2008 R2上禁用Filestream以启用镜像?

#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存储和数据库启用数据库镜像”。