Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [filestream]

24 questions
6
votes
1 answer

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into the DB tables. The point is that now and then it…
fdierre
  • 161
  • 4
4
votes
2 answers

SQL Server: How to shrink FileStream files?

For a project, I'm using a SQL Server 2008 R2. One table has a filestream column. I've made some load tests, and now the database has ~20GB used. I've empty tables, except several(configuration tables). But my database was still using a lot of…
J4N
  • 167
  • 1
  • 2
  • 8
3
votes
1 answer

Existing tables with binaries to use filestream

I've got a few tables for which I want to use filestream storage. These tables already contain binary data and have rowguids. However at the time they were were created, the tables were not added to a filestream enabled filegroup. What is the best…
user1098487
  • 133
  • 5
2
votes
2 answers

How to reattach sql 2008 database without filestream?

I have a sql 2008 database that had a filestream. Unfortunately, all I have is the .mdf and .ldf files. I no longer have access to the filestream .hdr file or anything that was in that directory. Normally, you can just reattach the database to a…
NotMe
  • 3,772
  • 7
  • 30
  • 43
2
votes
2 answers

Can we use FILESTREAM in case of SQL Server cluster

I saw this point on Technet article about RBS. The local FILESTREAM provider is supported only when it is used on local hard disk drives or an attached Internet Small Computer System Interface (iSCSI) device. You cannot use the local RBS…
Frank Martin
  • 721
  • 2
  • 10
  • 23
2
votes
3 answers

Enabling filestream on SQL Server 2008

When trying to enable filestream to a SQL Server 2008 I've got this message: There was an unknown error applying the FILESTREAM settings. Check the parameters are valid. And now in the FILESTREAM tab of the properties of said server I read: A…
Pablo
  • 7,249
  • 25
  • 68
  • 83
1
vote
2 answers

Sql Server 2008 Web Licensing / Edition Limitations

Possible Duplicate: Can you help me with my software licensing question? How is Sql Server 2008 Web licensed? When clicking on how to buy on the Microsoft pages it shows only SPLA pricing of $15 per processor per month. Does that mean it's only…
Chris Marisic
  • 1,404
  • 8
  • 33
  • 51
1
vote
1 answer

SQL Server 2008 SP2 installed, filestream failing

I ran the installer for SQL Server 2008 Service Pack 2. Somehow I missed the part that says "this completely screws you over". Regardless, we had a couple databases with filestreams. I followed some links and got the server itself operational. …
NotMe
  • 3,772
  • 7
  • 30
  • 43
1
vote
1 answer

FILESTREAM waits

I'm using a FILESTREAM enabled database that is hosted on SQL Server 2008 Standard Ed on a Windows 2003 server and am seeing some long waits of types PREEMPTIVE_OS_%. Specifically, PREEMPTIVE_OS_GETFILESIZE when executing…
electricsk8
  • 65
  • 5
1
vote
1 answer

How do I set the UNC permissions on a SQL Server 2008 Filestream UNC?

I have a SQL Server 2008 instance. I have configured filestream access properly, and use it from one column on one table in one of my databases. However, I cannot access the UNC share for the filestream data. I have tried browsing to it as well as…
Justin Dearing
  • 1,017
  • 10
  • 33
0
votes
1 answer

Migrating FileStream database to Azure

We are migrating our existing client databases to Azure soon. Our current database uses FileStream and has some data stored in columns of type varbinary(max). From what I have read, FileStream is not supported in Azure. How would we be able to…
chuckw87
  • 101
  • 1
  • 2
0
votes
3 answers

SQL 2016 - FILESTREAM feature is disabled. (bogus message)

I'm having problems getting filestream to work. I know how to configure it, and have setup numerous servers running it. For some reason, even though Filestream is definitely enabled, I keep getting this error when trying to restore a filestream…
user1751825
  • 313
  • 5
  • 13
0
votes
1 answer

file system not supported error while adding a file to sql filegroup with filestream

i am a beginner with sql server 2008, i was trying to add a file to a filegroup so that i an create a table which uses filestream, but i keep getting an errors. here is the code that i am trying: ALTER DATABASE dbtry1 ADD FILEGROUP…
Sneha
0
votes
1 answer

How to restore a database removing the filestream data

I have a 50GB SQL Server 2008R2 database backup. I'd like to restore only the "tables" and not the filestream data (the blobs saved as filestream). This is because I fon't have 100GB free (50 needed to copy the file on the server, 50 to restore the…
user193655
  • 253
  • 1
  • 5
  • 17
0
votes
1 answer

SQL Server filestream access from another computer using system account

I have a SQL Server 2008 set up to use filestream. SQL Server runs under a domain account with SPN set and delegation enabled. Accessing filestream from another computer using a domain account works. But accessing filestream from another computer…
Andrew J. Brehm
  • 1,611
  • 7
  • 34
  • 57
1
2