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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy