How to move non structured data from local DB in SQL 2005 and transfer it to a diferente repository ?

The "non structured data" in local DB represents 85% of overall information (namely in documents format ("BLOB")) and the local and central problems with storage reached the limit. The application over SQL 2005 local is a legacy solution actually in VB6. I didn't find in SQL Server 2005 any "way" to "retire" these data (for example "file stream") to a an alternative structure.

more ▼

asked May 20, 2013 at 10:06 AM in Default

avatar image

20 1 1 3

How much data are we talking about here anyway?

May 20, 2013 at 10:40 AM ThomasRushton ♦♦

The documents stored in local SQL Server 2005 are used by a court application, essential to manage daily law court acivities. The non structured data are joint with structured data but as to heavy (85% vs 15%) are surcharging the application performance and delaying the "backups". We don't want to move the data to a document management solution. Instead, we want to move the non structured data out of local DB to enhance performance and storage process, but the local application needs continuous that data (documents). What architectural scenarios (in SQL 2005) may be available to store the documents data ? Thanks

May 20, 2013 at 11:09 AM FranciscoE

How much data? How many GB, how fast is it growing?

May 20, 2013 at 11:17 AM ThomasRushton ♦♦

330 Local DB (1 by court) 220 Physical 110 Virtualized 31 Tb of total data, with 27 Tb related to non structured data Average Growth- 620 Mb/Month


May 20, 2013 at 04:17 PM FranciscoE

So that's, what, 100GB per DB? Or are some databases just a few gig, and some others in the Terabyte range?

May 20, 2013 at 05:24 PM ThomasRushton ♦♦
show all comments (comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

In general terms, it sounds as though you want / need to replace your SQL Server-based document repository with something that's a bit more like a traditional document management system.

Long time ago, I used to work on systems like this, but that was a while ago, so I'll be interested to hear what the rest of the #AskSSC gang makes of it.

more ▼

answered May 20, 2013 at 10:40 AM

avatar image

ThomasRushton ♦♦
42.2k 20 57 53

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 20, 2013 at 10:06 AM

Seen: 906 times

Last Updated: May 21, 2013 at 03:35 PM

Copyright 2018 Redgate Software. Privacy Policy