SQL Server 2008 FileStream 的配置及示例
1. 啟用 SQL Server 2008 Filestream 功能
a. 開始/所有程序/SQL Server 2008/Configuration Tools/SQL Server Configuration
b. 選中Service,右鍵屬性
c. 切換至Log On選項(xiàng)卡,設(shè)置如下圖

d. 切換至FileStream選項(xiàng)卡,設(shè)置如下圖

e. 點(diǎn)擊OK結(jié)束設(shè)置
f. 在Management Studio中查看數(shù)據(jù)庫的屬性

2. 創(chuàng)建數(shù)據(jù)庫和數(shù)據(jù)表
--Create Database CREATE DATABASE FSTtttt ON PRIMARY ( NAME = FSTtttt, FILENAME = 'E:\Database\FSTtttt.mdf' ), FILEGROUP FSG00001 CONTAINS FILESTREAM ( NAME = FSTtttt_fs, FILENAME = 'E:\Database\FSTtttt_fs' ) LOG ON ( NAME = FSTtttt_log, FILENAME = 'E:\Database\FSTtttt_log.ldf' ) GO USE [FSTtttt] GO --Create Table CREATE TABLE [dbo].[FSTest]( [Id] [uniqueidentifier] ROWGUIDCOL NOT NULL, [FileName] [nvarchar](64) NULL, [FileData] [varbinary](max) FILESTREAM NULL, UNIQUE NONCLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] FILESTREAM_ON [FSG00001] GO
3. 注意事項(xiàng)
當(dāng)數(shù)據(jù)庫被備份一次之后,使用 Delete 無法刪除對(duì)應(yīng)的文件,這時(shí)可以修改數(shù)據(jù)庫的恢復(fù)模式為簡單(Simple),執(zhí)行以下腳本即可
ALTER DATABASE FSTtttt SET RECOVERY SIMPLE GO CHECKPOINT GO ALTER DATABASE FSTtttt SET RECOVERY FULL GO
4. 示例下載
我的資源中存儲(chǔ)讀取圖片的示例

浙公網(wǎng)安備 33010602011771號(hào)