SQL 2000 Large database

Posted on 2010-03-25
Medium Priority
Last Modified: 2012-06-27
We have a database that has grown to 350 GB over a five year period. I was trying to figure out a way to split this data whiles keeping it accessable. any ideas would be helpful

Question by:arahming
LVL 10

Accepted Solution

myrotarycar earned 1000 total points
ID: 28582261
You could partition the data across mutliple data files belonging to your PRIMARY file group and place those files on different spindles -that might give you a performance boost. You would have to cap the growth of you current data file and allow the new data files to grow freely -cap it though to avoid nasty surprises.
If, on the other hand you are looking to "start fresh" or archive data which needs not be part of the working DB, you need to analyze your DB at the object level to figure out which objects are required to server your client (i.e. your application) and which ones are there doing nothing more than bloating your DB. Suffice it to say, this is far more involved than the single paragraph I am providing.
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 1000 total points
ID: 28584395
Hello arahming,

why dont you delete/purge some old data to another database



Author Comment

ID: 28652972
I am not a sql pro I have a understanding of simple thing like queries and moving databases but my boss doesn't want to pay GE the people who created the DB the money to do these techniques so if someone has a technet article or some how to's it would be appreciated



Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question