Archive/Split a large SQL database and should be accessiable

  • 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.

  • 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"

  • Yes it is SS2k, is it major changes or minor changes. If possible could you please explain the process?

  • 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"

  • 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