sharepoint运行服务器场备份时出错了 RRS feed

  • 问题

  • sharepoint运行服务器场备份时,出现如下错误信息:备份目标 "\\KM" 支持 FILESTREAM 文件组。此文件组不能用作备份目标。请使用有效的备份目标重新运行 BACKUP 语句。
    2012年9月20日 2:40


  • 你好 裴育,

    When runninng a backup
     SPFarm-backup-Directory \\ server\SHPTBackup-BackupMethod Full-Item "WSS_Content_80_applicatif"-verbose

     backup has errors

     FatalError: Failed to object in the event WSS_Content_80_applicatif OnBackup
     .For more information, see the file or spbackup.log sprestore.log d
     year the backup directory.
             SqlException: Backup destination "%.*ls" supports a FILESTREAM filegroup. This filegroup cannot be used as a backup destination. Rerun the BACKUP statement with a valid backup destination.

     BACKUP DATABASE is terminating abnormally. Cause
    known issue Resolution
    we  removed the desktop experience feature from the server and the backup started working Additional Information
    The reason this is happening is that SQL Server 2008 added support for filestream filegroups for databases.  It appears that SQL has some sort of check to ensure that database backups cannot be stored in the same location as a filestream filegroup.  To check if this is the case, SQL Server attempts to look for a file called filestream.hdr on the file share.  It uses a standard UNC path name to look for this.

    The OS on the SQL server first attempts to find this file using SMB.  That fails.

    The OS then attempts to find this file over DAV using the WebClient service.  The WebClient service issues PROPFIND requests for /filestream.hdr to port 80 of the server hosting the network file share.

    PROPFIND /filestream.hdr HTTP/1.1
    Content-Length: 0
    Depth: 0
    translate: f
    User-Agent: Microsoft-WebDAV-MiniRedir/6.0.6001
    Host: server3
    Connection: Keep-Alive
    Cookie: WSS_KeepSessionAuthenticated={6bc2b09d-20fc-4eca-bb32-24e7c636ee3a}; SDA_Callback=03/31/2009 22:40:19

    Because a SharePoint web application is running on port 80, SharePoint's DAV code will attempt to handle this request.  Due to workarounds required in SharePoint to support Windows Explorer's behavior when connecting to DAV-based shares, SharePoint will claim that this resource exists even though it doesn't:

    Cache-Control: no-cache
    Content-Length: 767
    Content-Type: text/xml
    Server: Microsoft-IIS/7.0
    SPRequestGuid: 000b7f46-887b-4778-ba83-cec5bb0a9d77
    Set-Cookie: WSS_KeepSessionAuthenticated={6bc2b09d-20fc-4eca-bb32-24e7c636ee3a}; path=/
    Set-Cookie: WSS_KeepSessionAuthenticated={6bc2b09d-20fc-4eca-bb32-24e7c636ee3a}; path=/
    X-Powered-By: ASP.NET
    Date: Wed, 01 Apr 2009 05:40:21 GMT

    <?xml version="1.0" encoding="utf-8" ?>
    <D:multistatus xmlns:D="DAV:" xmlns:Office="urn:schemas-microsoft-com:office:office" xmlns:Repl="" xmlns:Z="urn:schemas-microsoft-com:">
    <D:status>HTTP/1.1 200 OK</D:status>

    As a result of this response from SharePoint, the WebClient DAV mini-redirector will tell SQL Server that the file/folder exists.  SQL Server will then fail, believing that this is an indication of a filestream filegroup being present.

    Several workarounds are possible:

    Do not install the Windows Desktop Experience feature on the SQL server.  If you do not have this feature installed, then the WebClient service will also not be installed and the OS will not be able to attempt to connect to network resources using DAV.
    If you do have the Windows Desktop Experience feature installed on the SQL Server, do not start the WebClient service.  This way, the OS will not be able to attempt to connect to network resources using DAV.
    Do not attempt to back up to a server that has a SharePoint web application running on port 80.  This way, SharePoint's DAV code will not be able to intercept the request and give a misleading response.
    If you must back up to a server that has a SharePoint web application running on port 80, create a filestream.hdr file in your IIS home directory that hosts your SharePoint web application on port 80, then run iisreset.  The next time the IIS web site serving port 80 starts, SharePoint will scan for files and folders in its IIS home directory and automatically consider them to be exclusions.  As a result, SharePoint will let IIS handle requests for that file, including DAV-based requests.  Unless you've given the SQL Server's service account access to that web application, IIS will return an HTTP 404 response to the PROPFIND request, allowing SQL Server to think that no file is there and it is free to proceed with the backup. "


    2012年9月21日 8:09