Hi, You could also leverage SQL 2005 partitioning. This way you can split a table by a date and move data/index to a slower set of disk. Only con is that you have to use Enterprise edition. http://www.microsoft.com/technet/prodtechnol/sql/2005/spdw.mspx Regards EG Utility Michael Troelsen
_____ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subbu Sent: 23. maj 2007 21:58 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: AX data management/archiving starting at 45K??? too much asking price for a buy..rather I will assign this to SQL group for a batched archiving for top 1o tables periodically --- In Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED], "James Flavell" <[EMAIL PROTECTED]> wrote: > > Wow 45,000 dollars is not cheap...I could probably buy a server that kicks > out enough performance to be able to handle all my data without doing > archiving for that kinda money... > > Has anyone used this product? > > -----Original Message----- > From: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] > [mailto:Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] On Behalf Of Dishant > Singhal > Sent: 23 May 2007 11:58 > To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] > Subject: Re: [Axapta-Knowledge-Village] AX data management/archiving > > http://www.ignify. <http://www.ignify.com/DynamicsAXData.asp> com/DynamicsAXData.asp > > > ----- Original Message ---- > From: sri ram <[EMAIL PROTECTED]> > To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] > Sent: Wednesday, May 2, 2007 10:29:22 PM > Subject: Re: [Axapta-Knowledge-Village] AX data management/archiving > > Hi Cristoph, > > Sad to say that there no tool in market for archiving data in axapta. But > there is one in development on Ax 4.0 which is in the process of testing. I > had a chance of working with a client whose database is around 500GB. They > will be manually archiving data monthly from 20 tables in order to have > database to good size. > > Regards > Sri > > On 5/2/07, cdlmalherbe01 <cdlmalherbe@ mweb.co.za> wrote: > > > > Hi all, > > > > I'm looking for a data management/archivin g module/tool that has a > > proven track record on Dynamics AX. > > > > We are running AX 3.0 on SQL 2000 and our database has increased to a > > size of 100GB in 3 years. > > > > We're looking for a tool that will preferably archive data to an > > inactive AX database while maintaining referential integrity. > > > > Any suggestions? > > > > Best regards, > > > > Christoph Malherbe > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > __________________________________________________________ ______ > ________ > The fish are biting. > Get more visitors on your site using Yahoo! Search Marketing. > http://searchmarket <http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php> ing.yahoo.com/arp/sponsoredsearch_v2.php > > [Non-text portions of this message have been removed] > > > > Sharing the knowledge on Axapta. > Visit www.frappr.com/axapta for axapta friends. > > Come and choose your preferred name for Microsoft Dynamics AX on the Axapta > Knowledge Village, Visit www.axapta-knowledge-village.tk > > > Yahoo! Groups Links > [Non-text portions of this message have been removed]