0

When I do a restore of a database from a database_snapshot on a filestream enabled database, I am getting the error:

The database cannot be reverted because FILESTREAM BLOBs are present.

Is it just not possible to do a restore from snapshot or do I have to specify something extra in the restore command?

1 Answer 1

0

From the docs:

FILESTREAM filegroups are not supported by database snapshots. If FILESTREAM filegroups exist in a source database, they are marked as offline in its database snapshots, and the database snapshots cannot be used for reverting the database.

! Note

A SELECT statement that is executed on a database snapshot must not specify a FILESTREAM column; otherwise, the following error message will be returned: Could not continue scan with NOLOCK due to data movement.

So no it's not possible to revert using it. You might try setting that filegroup to read-only, as then it doesn't need to be reverted, but that probably also doesn't work (and obviously you couldn't modify the blobs).

1
  • thx for the quick answer
    – Ludo
    Apr 3 at 7:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.