June 30, 2009 at 11:04 am
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?
August 1, 2009 at 11:35 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply