FILESTREAM Restore

  • I have a developer with a local instance of SQL Server 2008 with FILESTREAM enabled. A database on that instance has been setup using FILESTREAM. Then a database backup is run.

    The bak file is then to be restored onto another instance of SQL Server 2008 with FILESTREAM enabled. This new instance is on a clustered server. When DBCC CHECKDB is run on the newly restored database, I get the following error:

    The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'FindFirstFile' on drive location.

    Further down in the CHECKDB details I have the following error:

    Table error: The FILESTREAM directory ID ID for column ID column ID of object ID object id, index ID index id, partition ID partition id was not found.

    I can select records from other tables within the database but not from tables that hold FILESTREAM information.

    Does FILESTREAM have an issue with a restore when the drive names and locations have changed?

  • When using FILESTREAM in a clustering environment, you should always create the FILESTREAM file group on a shared disk volume. Is this true in your environment?

    .

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply