SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


HSM(Hierarchical Storage Management)


HSM(Hierarchical Storage Management)

Author
Message
mayrobi
mayrobi
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 1
Hello All,
Does anybody knows what is the best HSM
(Hierarchical Storage Management) solution for SQL Server 2000?
I read about Legato HSM product and Windows Remote Storage but I need a more information for HSM solution that specifically related
with SQL Server.
Any Advice will be highly appreciated.

TIA
-mayrobi-



Wesley Brown
Wesley Brown
SSCommitted
SSCommitted (2K reputation)

Group: Moderators
Points: 1981 Visits: 442
Wow, I'm not sure what HSM even does. I may just be slipping a cog can you describe what the product allows you to do?

Wes

http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
mayrobi
mayrobi
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 1
It is a kind of Storage Management system that automatically grooms files by migrating infrequently accessed
data to near-line and offline storage (Optical Drive, DLT etc) on the basis of criteria such as age and size of the file.

Infact, it mainly used for legacy system (Mainframe, RISC based etc) but
Some vendors like veritas, IBM Tivoli and Legato sell such as product (running under windows)but only for
File Sever and Exchange (Veritas Only)

What I actually need is a tool, method or system that can maintain 12 years of Transaction Data Efficient and effectively within SQL Server database.

Do you have an option to HSM ?

Thanks
-mayrobi-

>>>>>>>>>>>
Wow, I'm not sure what HSM even does. I may just be slipping a cog can you describe what the product allows you to do?

Wes



Wesley Brown
Wesley Brown
SSCommitted
SSCommitted (2K reputation)

Group: Moderators
Points: 1981 Visits: 442
Do you need to call a single record inside of twelve years near real time? What are the time constraints. At my last job we kept a SQL server on stand by that got a restore of any database backups that had data not in the database anymore due to pruneing. I used a script to move data past a date out of the online "hot" databases into a near line system. From there anything 6 months or older was moved to the archive database server and backed up onto tape. If we needed something from a year or more ago it got restored to the stand by reporter server and data pulled from there. We were suppose to covert all the old data from other DB formats aka sql 6.5 and back to sql 7/2000 I quit before we did that though. I personally don't know of a out of the box tool that will allow what you want. Most of the big backup packages legato veritas have a point in time restore but I don't know how they would handle 12 years though.

Wes

http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
mayrobi
mayrobi
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 1
I understand what you mean. I think
keeping online 12 years transaction is
such as unusual jobs.
But my customer requires this to be implemented: "Capability to show/create transaction data/report with 12 years retention".
If I create sql scrip to move data older than 1 year to stand by server and we backup the data then the customer has to restore the data before they can have the report they want.
Is there any other solution to this issue?

Thank You
-mayrobi-



sjcsystems
sjcsystems
SSC Veteran
SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)

Group: General Forum Members
Points: 285 Visits: 1
This is not a recommendation!! Try a look at : www.storesmarter.com (Princeton Softech), they advertise in SQL Server magazine. This is an Active Archiving solution - not exactly what you want, but close I think.
Regards
Simon



mayrobi
mayrobi
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 1
Hi Simon,
Thank you..
I think this is what I Actually Need.
Active archieve seems just like HSM concept.
But the product specialize on Oracle and DB2.
Is there any reference for this product that it can run smoothly on top of SQL Sever 2K.

Thanks Again

Regards
-mayrobi-



sjcsystems
sjcsystems
SSC Veteran
SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)SSC Veteran (285 reputation)

Group: General Forum Members
Points: 285 Visits: 1
I just went to their site for the first time. It definitely mentions SQL Server, so I see no reason why not, but I haven't looked at all the white papers etc.
I hope it's what you're looking for,
Simon



Steve Jones
Steve Jones
SSC Guru
SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)SSC Guru (148K reputation)

Group: Administrators
Points: 148985 Visits: 19446
I'd be very careful here. HSM has matured, but I used to use it in an imaging solution and it was sssssllloooowwwww at times looking for old images. Not sure how the query processor will deal with this.

I think burthold has the best solution and we used to do something similar. We built 3 dbs, one for real time (usually 1 yr), another for near, which was a slower server, but had another couple years worth of data and a 3rd older server with everything else. We used views and stored procedures (nd linked servers) to check if you wanted old data and then Unioned the queries from other linked servers if we neede them. With SQL 2000 and federated Database servers you could do the same thing.

Steve Jones
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Wesley Brown
Wesley Brown
SSCommitted
SSCommitted (2K reputation)

Group: Moderators
Points: 1981 Visits: 442
a horazontally partitioned view would do nicely here. I remember HSM now in radioligoy labs used to retrive old xrays and the like.

Wes

http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search