Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

problems about databases

Hi all,
I use the MS SQL SERVER database , with the more and more devices added to the system,the database becomes very big. I found the system
has not the function of deleting the data from the database.For example, I want to delete the data before 2006-2-1 in the InterfaceTraffic table. But the system did not provide the function.
Has anyone know it? Or I should delelop a database management system to delete data?

Find more posts tagged with

Accepted answers

All comments

martek01

Go into the database manager and run a compact database. I just dropped the size of mine from over a gb to 700 mb.

Evans Martin

---
Evans L. Martin - IS Analyst
Metro Govt. of Nashville, TN & Davidson County
615.862.4066 Office 615.862.6288 Fax AOL AIM: Martek01