Home / server / Questions / 450044
In Process
aleroot
Asked: 2012-11-20 02:31:37 +0800 CST

Delete data from a SQL Server database on a full partition

  • 772

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 ?

sql-server-2005

1 Answers

  1. SQL Server cannot perform the operation because the transaction log is full; it has nothing to do with the data file(s).
    As long as there is still space in the transaction log, SQL server will not stop working.

    You need to find out if and why the transaction log is full:

    DBCC SQLPERF (LOGSPACE)

    What you can try is to switch the DB to SIMPLE recovery:

    ALTER DATABASE YourDB SET RECOVERY SIMPLE

    If it doesn't free up space, see what is preventing it:

    SELECT log_reuse_wait_desc FROM sys.databases WHERE name = 'YourDB'
    • 0