Tag Info

New answers tagged

-2

Yes, you can. See: Set Up FILESTREAM on a Failover Cluster, https://msdn.microsoft.com/en-us/library/cc645886(v=sql.110).aspx


0

I had the same problem. Eventually I worked out that I needed to change the db recovery model from "Full" to "Simple", and then I could delete my filestream files.


0

Indeed, that was the answer. I set the db recovery model to "Simple", waited a minute for the filestream data to clear up, and then I could remove the filestream file and filegroup.


1

A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB This error can be caused by transient, timing-related errors, or by in-memory or on-disk data corruption. This message also says ...


0

You can simply restore the Database without any database file. Try this: RESTORE DATABASE [yourDatabase] WITH RECOVERY It won't hurt your database. It will just remove the IN RESTORING-State and you can then run your DBCC CHECKDB and whatever you want.


1

You can't move the column without copying the data. There's one rather exotic idea to pull this of: You move all other columns and leave the filestream column in place. Depending on the number of rows and schema changes required this can be a lot faster (or slower). You might have to completely gut some tables and create complicated scripts. I only would do ...


0

No I don't know any way to do this. Just make an INSERT or UPDATE on the other table. You can detach whole partitions of a table and move them to another table. But not just one column. Why don't you just want to copy/move the data?



Top 50 recent answers are included