The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
7 views

Can I use RBS RemoteFilestream Provider in a computer not in domain of the server?

I installed Remote Blob Storage (RBS) and I'm able to store and retrieve objects blobs in the same computer where I installed the server + client components. In another computer (client) I installed ...
0
votes
1answer
63 views

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 ...
0
votes
2answers
396 views

Is it possible to restore database without Filestream

I have actually a small Production Filestream enabled database. Data (150 Mo) + Filestream (500 Mo). Tomorow, the filestream will grow until 30 Go... I have many Test Databases that I want to ...
3
votes
1answer
454 views

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 ...
3
votes
1answer
2k views

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 ...
0
votes
1answer
287 views

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. ...
0
votes
2answers
588 views

An mdf file of a Sql server 2008 database is bigger than expected

I have a Sql server 2008 database that contains many images. In theory they should make up most of the space on the database. I moved the images to Filestrem fields but the size of the mdf didn't ...
0
votes
2answers
2k views

Change SQL Server FileStream Path

I would like to change the path for a SQL Server Filestream but I can't find any information on this. I know how to change the mdf and ldf filenames, but can't seem to find how to change the folder ...
1
vote
1answer
1k views

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 ...
0
votes
1answer
211 views

FILESTREAM Enabled Database and Backup Compression

I have a +150Gb FILESTREAM enabled database growing steadily +10Gb weekly, and am curious if anyone has any recommendations | familiarity regarding compression ratios for database backups. I tried ...
2
votes
1answer
921 views

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 ...
1
vote
1answer
89 views

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, ...
0
votes
2answers
86 views

Defragment a FILESTREAM data container

Has anyone ever tried to defrag a FILESTREAM data container using the Windows Disk Defragmenter? Does this work without taking the FILESTREAM enabled database offline? If this doesn't work, can ...
0
votes
2answers
572 views

Migrating from filestream to “classic” blob

I am considering moving all my customers' DBs to SQL Azure. I am using a single FILESTREAM field to store files in blobs (not for performance on large blobs), but simply because I am using the Express ...
1
vote
1answer
887 views

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 ...
1
vote
2answers
1k views

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. ...
1
vote
2answers
3k views

Sql Server 2008 Web Licensing / Edition Limitations [duplicate]

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 ...
0
votes
1answer
440 views

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

hi 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: ...
2
votes
3answers
2k views

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 ...