.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

SQL Server FileStream

Posted By:      Posted Date: September 25, 2010    Points: 0   Category :Sql Server
 

Hi all....

I want to create a FileStream enabled Database in Sql Server 2008 R2 ...every thing is fine but when I create A filestream file in that Database the Execution of the Query take too long to execute and seems to be hanged ... i am using following Queries of Database Creation :

Use Master
GO
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'FileStreamDB')
DROP DATABASE FileStreamDB
GO


USE master
GO

-- Create FileStreamDB Database
CREATE DATABASE [FileStreamDB] ON PRIMARY 
( NAME = N'FileStreamDB', FILENAME = N'D:\FileStreamDB\FileStreamDB.mdf' , 
SIZE = 10MB , MAXSIZE = UNLIMITED, FILEGROWTH = 10% )
LOG ON 
( NAME = N'FileStreamDB_log', FILENAME = N'D:\FileStreamDB\FileStreamDB_log.ldf' , 
SIZE = 10MB , MAXSIZE = UNLIMITED , FILEGROWTH = 10%)
GO

ALTER DATABASE [FileStreamDB] 
ADD FILEGROUP [FileStreamGroup] CONTAINS FILESTREAM 
GO

ALTER DATABASE [FileStreamDB] 
ADD FILE (NAME = N'FileStreamDB_FSData', FILENAME = N'D:\FileStreamDB\FileStr


View Complete Post


More Related Resource Links

how to upload files (5MB-50MB) into sql server 2008 by using filestream

  
Hi!i have some files, and i need to upload these files into sql server 2008 by using filestream.lets take table name as custfiles,              columns are fileid,filename,filepath,filesize.1.how to create table using filestream?2.how to insert file (record) into table from .net environment?3.how to retrive that file from .net environment?please provide related code....THANS FOR ANY HELP

Can't enable filestream on SQL Server 2008 Express 64bit under Win 7(64 bit WOW)

  
I have a newbie question.  I am running Win7(64 bit WOW). I installed SQL Server 2008 Express R2 (64 bit), but when I go to enable filestream, it reports that my edition of SQL Server does not support filestream.  I thought that the 64 bit edition would.  It says to install SQL Server 2008 64 bit.  Am I correct that that is not a free download?  Do I have any other options?

SQL Server 2008: When creating database with filestream group pc hangs

  
Hello,

I am facing this STRANGE problem with sql server 2008. When I try to create a new database with filestream group my system hangs. When I restart pc by direct power off and then on, I cannot see the new database but at the given location I could see that database files and filestream group has been created. 

Solutions Tried.
Uninstall, download new version then reinstall but to no use.
Set maximum permissions to current user (according to my knowledge).
Using Mix mode authentication.


PC configuraion:
XP Home Edition SP2,
Intel Dual Core 2.0 GHZ Processor
4GB Ram,
SQL Server express SP1 installed on NTFS Partition
Plenty of Disk Space
Comodo Firewall pro, Avast Antivirus ( Already tried to stop firewall and antivirus still no use)

Any help would be appreciated.

SQL Server 2008 R2 FileStream

  

Hi all,

I am trying to create a Filestream Enabled database in sql server 2008 R2 but I am not succeeding...I had Posted my problem on this Forum few days back also but still not got a satisfactory answer...

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/b0b5e97a-be3c-4833-bf93-68e464d69eee/#c7721fe3-1138-4abf-9db0-3d929ffdcd37

I have found another links with similar problem but no one with satisfactory reply...

also I found following link

https://connect.microsoft.com/SQLServer/feedback/details/557853/filestream-feature-is-disabled-on-sql-server-express-2008-r2-for-win7-ult-64?wa=wsignin1.0#details

which states that you must Login as Admin before creating FileStream enabled Database...I tried but that also of no help, i want to know if there is still an issue with Sql server 2008 R2 Filestream.

Thanks and Regards,

WolverineV9


Problem with Filestream in sql server 2008

  
Hi,
I am tryng to implement the filestream feature provided with sql server 2008. After writing to the file stream file using win32 API i am trying to commit the transaction . Upon doing so i am getting the following error "An uncommittable transaction was detected at the beginning of the batch. The transaction was rolled back. This was caused by an error that occurred during the processing of a FILESTREAM request in the context of this transaction. " I am hitting the remote server where the filestream data is saved.

I checked the @@TRANCOUNT inside my transaction and it showed as 1. I assume this means that there is only one transaction.
I am using c# code to write the file stream file to the path got by column.PathName().

The brief steps are as given below:
1)Hit the DB and get the UNC path of the file. The server is remote and not local.
2) Begin a transaction.
3)Get the transactional context by using  GET_FILESTREAM_TRANSACTION_CONTEXT().
4) Write some data to filestream.
5)Commit the transaction.

I am getting the error when i am trying to commit the transaction.
I checked the path where this file is stored and a new file with the data i have written is created, but it is not getting reflected in my datarow as the transaction is not committed.

The code goes as

Installing & configuring Remote BLOB Storage (RBS) with the FILESTREAM provider (SharePoint Server 2

  

Hi,


I really do not know the reason, how much ever i tried; I am NOT getting message in "rbs_install_log.txt" like; “Product: SQL Remote Blob Storage -- Installation completed successfully.”


I can see Several tables residing under the content database with names that are preceded by the letters "mssqlrbs".

In Object Explorer, right-clicking  <DatabaseServer>, and then clicking Properties; In the Server Properties dialog box, clicking Advanced, clearly shows that the FilestreamAccess Level is set to Full access enabled

Right-clicking  the content database name, and then clicking Properties,
when I check the Database Properties dialog box by clicking Filegroups,
I see that,  in the Filestream list, RBSFilestreamProvider appears. Even under Files, in the Database files list, RBSFilestreamFile appears

------------------------------------------------------------------------------------------------

use [ContentDbName]







if not exists 

Installing & configuring Remote BLOB Storage (RBS) with the FILESTREAM provider (SharePoint Server 2

  

Hi,

Hi

Based on many blog posts / articles on Remote BLOB Storage with FileStream Provider,  I could easily do for one Web-Application. It is working fine too. But my Issue is, I have 3 Web-Applications in turn 3 Content Databases. Out of three, anyway 1st one went smooth since I followed all the steps. For the next two Content Databases, I am facing Issues like; When I tried;

use [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c]
alter database [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c] add file (name = RBSFilestreamFile, filename = 'c:\Blobstore') to filegroup RBSFilestreamProvider

It is giving;

Msg 5520, Level 16, State 2, Line 1
FILESTREAM file 'RBSFilestreamFile' cannot be added because its destination filegroup cannot have more than one file.

If I try with another Folder for example; c:\Blobstore_2ndWebApp

use [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c]
alter database [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c] add file (name = RBSFilestreamFile, filename = 'c:\Blobstore_2ndWebApp') to filegroup RBSFilestreamProvider

I get Command(s) completed successfully.

But when I run below piece of code with my values;


msiexec /qn /i

Using bitlocker with Filestream on a Server Cluster

  

Hello -

We are developing a system to stream sensitive data to remote clients. Currently, we are planning on storing the data using FILESTREAM, however, it appears that the recommended solution for encrypting FILESTREAM data is BitLocker Encryption.

From what I can tell, BitLocker won't work on a clustered server. So, is there a work-around to this? The application we're developing would be critical to our customers and would almost certainly run on a cluster.

Scott


Anybody ever seen FILESTREAM totally wedge a server?

  

And I mean totally. Couldn't RDP to it, couldn't log in at the console, couldn't connect to DAC on SQL Server, couldn't remote reboot it via WMI, and all the SNMP agents on the machine stopped reporting data.

Our server is running SQL Server 2008 SP1 CU7 Enterprise x86 on Windows 2003 Enterprise x86. Last night I enabled FILESTREAM for the instance, which worked without any problem. This morning, I created a FILESTREAM filegroup for a database. Also no problem there. Then I tried adding a FILE to the FILESTREAM filegroup. The ALTER DATABASE...ADD FILE query appeared to be taking an extremely long time to execute, but sys.dm_exec_requests didn't show anything unusual. Also, the directory I told it to use (a subdirectory underneath the default data directory) had been created successfully, and there was a filestream.hdr file in it.

Then things started going wrong. Connections were timing out, I couldn't kill the query doing the ADD FILE, and eventually my RDP session froze dead in its tracks, along with pretty much everything else on the server. The Windows event logs mostly went quiet at this point, except for the security log which tells me that Kerberos was still working fine oddly enough. The last thing in the system event log is the driver \Device\RsFx0103 coming online, which appears to be the FILESTREAM driver.

Eventually, I had to forcibly

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend