New answers tagged filestream
Yes, you can. See: Set Up FILESTREAM on a Failover Cluster, https://msdn.microsoft.com/en-us/library/cc645886(v=sql.110).aspx
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.
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.
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 ...
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.
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 ...
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