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!

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

Can data be purged from the ePO Server database?

ePO Server

Can data be purged from the ePO Server database?

by  TumbleWeed2000  Posted    (Edited  )
Short answer is no. There is no way to remove data from the database. At least not with the ePO server software.

There are utilities that allow you to purge data, the result of a purge is that the data does not get included in any reports there after. The database size is not reduced as a result of the built in purge.

If your using the MSDE engine then your out of luck when you hit a database size of 2GB because the engine refuses to work.

According to Network Associates the only solutions to this are:

1.)Uninstall and re-install so the database gets deleted and recreated from scratch.
2.)Manually delete and re-create the database.
3.)Upgrade to a full SQL server.
4.)Contact Microsoft for any possible solution.

If you currently have a SQL server, see below.

Lordyboy(MIS) submited the following on Feb 13, 2003:

Having read the FAQ we purge the data from our MSDE database in the following way: If you attach to the MSDE database via an SQL 7 installation you can truncate the logs which will give you back the space required. This is how we maintain our MSDE database

Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top