Post reply

HSM(Hierarchical Storage Management)

  • August 22, 2002 at 10:12 pm

    #158297

    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-

  • August 22, 2002 at 10:28 pm

    #435152

    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

  • August 23, 2002 at 12:42 am

    #435154

    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

  • August 23, 2002 at 1:45 am

    #435157

    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

  • August 23, 2002 at 2:31 am

    #435158

    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-

  • August 23, 2002 at 2:52 am

    #435159

    This is not a recommendation!! Try a look at : http://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

  • August 23, 2002 at 3:13 am

    #435162

    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-

  • August 23, 2002 at 3:20 am

    #435164

    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

  • August 23, 2002 at 10:41 am

    #435221

    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

  • August 23, 2002 at 10:53 am

    #435228

    a horazontally partitioned view would do nicely here. I remember HSM now in radioligoy labs used to retrive old xrays and the like.

    Wes

  • August 25, 2002 at 10:20 pm

    #435314

    Thanks Everybody for your suggestion..

    I think I would rely on SQL Server capabilities to meet the requirement.

    I am not confident with Princeton Softech since no MS recommendation made for the product. And I think its quite complicated the price is also high.

    Thanks Again..

    -maroby-

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply