April 9, 2009 at 6:32 am
How we can we successfully archive/Split a large SQL database and later users should be able to access both the present data and Archived/split databases?
This is in SQL server 2000 and could be without any changes to application, please assist.
April 9, 2009 at 6:45 am
Do you mean you want to partition your database in SS2K?
partitioning is possible from SS2K5. If you want to hv such feature in 2k then you hv to change ur db structure/queries.
"Don't limit your challenges, challenge your limits"
April 9, 2009 at 6:56 am
Yes it is SS2k, is it major changes or minor changes. If possible could you please explain the process?
April 9, 2009 at 7:01 am
I hv not done it in SS2k. though, hope below links will b useful to you...
http://msdn.microsoft.com/en-us/library/aa198334(SQL.80).aspx
johnjacobm.wordpress.com/2007/04/13/data-partitioning-in-sql-server-2000/
"Don't limit your challenges, challenge your limits"
April 10, 2009 at 7:06 am
Kruti,
Thank you..... It has some worth informaion.
Rohith.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply