HSM(Hierarchical Storage Management)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » HSM(Hierarchical Storage Management)

11 posts, Page 1 of 2

1 2 »»

HSM(Hierarchical Storage Management)

Rate Topic

Display Mode

Topic Options

Author

Message

mayrobi

Posted Thursday, August 22, 2002 10:12 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 29, 2005 12:05 AM
Points: 7, 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-

Post #6361

Wesley Brown

Posted Thursday, August 22, 2002 10:28 PM

SSChasing Mays

Group: Moderators
Last Login: Tuesday, May 07, 2013 3:54 PM
Points: 608, Visits: 379

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

Post #40218

mayrobi

Posted Friday, August 23, 2002 12:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 29, 2005 12:05 AM
Points: 7, 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

Post #40219

Wesley Brown

Posted Friday, August 23, 2002 1:45 AM

SSChasing Mays

Group: Moderators
Last Login: Tuesday, May 07, 2013 3:54 PM
Points: 608, Visits: 379

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

Post #40220

mayrobi

Posted Friday, August 23, 2002 2:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 29, 2005 12:05 AM
Points: 7, 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-

Post #40221

sjcsystems

Posted Friday, August 23, 2002 2:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 25, 2003 12:00 AM
Points: 117, 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

Post #40222

mayrobi

Posted Friday, August 23, 2002 3:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 29, 2005 12:05 AM
Points: 7, 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-

Post #40223

sjcsystems

Posted Friday, August 23, 2002 3:20 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 25, 2003 12:00 AM
Points: 117, 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

Post #40224

Steve Jones - SSC Editor

Posted Friday, August 23, 2002 10:41 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526, Visits: 13,863

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

Post #40225

Wesley Brown

Posted Friday, August 23, 2002 10:53 AM

SSChasing Mays

Group: Moderators
Last Login: Tuesday, May 07, 2013 3:54 PM
Points: 608, Visits: 379

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

Post #40226

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions