Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

HSM(Hierarchical Storage Management) Expand / Collapse
Author
Message
Posted Thursday, August 22, 2002 10:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, August 22, 2002 10:28 PM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
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
Posted Friday, August 23, 2002 12:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, August 23, 2002 1:45 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
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
Posted Friday, August 23, 2002 2:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, August 23, 2002 2:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Friday, August 23, 2002 3:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, August 23, 2002 3:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Friday, August 23, 2002 10:41 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:39 AM
Points: 31,176, Visits: 15,615
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
Posted Friday, August 23, 2002 10:53 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
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 »

Add to briefcase 12»»

Permissions Expand / Collapse