Empty SQL Server 2000 LDF File

1 vote

2 answers

1384 views

sql-server sql-server-2000

                          I have a 1 GB .LDF for a test database which I want to shrink right down. I am happy to delete its contents if needed.

How can I do this for SQL Server 2000?

I have tried the following to no huge avail:

    BACKUP LOG Database_TEST with truncate_only
    DBCC SHRINKFILE (Database_TEST_Log, 1000)

Asked by rhughes (325 rep)

Dec 10, 2013, 01:25 PM
Last activity: Oct 5, 2022, 05:17 PM

Empty SQL Server 2000 LDF File

Related Questions