Delete data from a SQL Server database on a full partition
- by aleroot
I have a SQL Server 2005 Database on a dedicated partition, during the time the database grown and now it have occupied all the space on the partition, now the problem is that the only operation I can do on the database is detach, but i want to remove old data from some tables to save space ...
How can I remove old data from the database if SQL Server interface doesn't allow to run queries on it ?