Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSDE - Archive Data

Status
Not open for further replies.
agoeddeke

agoeddeke

Programmer
Jul 23, 2002
201
US
Hello,

I want to be able to take some transactional data in my database and copy it off to another database as I near the 2 GB limit of MSDE. Once the first archive gets filled I'd like to automatically create a second archive database and copy transactions there. So eventually I would have somethinglike:

MainDatabase
Archive01Database (~2 GB)
Archive02Database (~2 GB)
Archive03Database (700 MB and growing... active archive)

Does this seem do-able and what is the best practice for taking records from one database, stuffing them in another and deleting them from the main?

Thanks,
Andy
 
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
957
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Data types and sizes
Replies
18
Views
1K
gmmastros
gmmastros
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller
marn1997
  • Locked
  • Question
Large data base to back word engineer
Replies
5
Views
342
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top