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

Archive/Split a large SQL database and should be accessiable Expand / Collapse
Author
Message
Posted Thursday, April 09, 2009 6:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 01, 2010 9:00 AM
Points: 9, Visits: 64
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.
Post #693920
Posted Thursday, April 09, 2009 6:45 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 09, 2011 2:49 AM
Points: 536, Visits: 412
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"
Post #693930
Posted Thursday, April 09, 2009 6:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 01, 2010 9:00 AM
Points: 9, Visits: 64
Yes it is SS2k, is it major changes or minor changes. If possible could you please explain the process?
Post #693944
Posted Thursday, April 09, 2009 7:01 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 09, 2011 2:49 AM
Points: 536, Visits: 412
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"
Post #693948
Posted Friday, April 10, 2009 7:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 01, 2010 9:00 AM
Points: 9, Visits: 64
Kruti,

Thank you..... It has some worth informaion.

Rohith.
Post #694796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse