asked on

Big Transcation Log File

I still have a very large Transcation Log File, so I ran these commands, and the LDF file is still big.

BACKUP LOG 'database' TO DISK='some_file_path'

and tried this:

BACKUP LOG 'database WITH TRUNCATE_ONLY

What can I do? Nothing happened.

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gtrapp

ASKER

The DBCC SHRINKFILE (yourlogfile ) is not working.

I get this error, but I have the right path to the file. I have used single and double quotes, but same error:

Could not locate file 'X:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\cf_pbtf_log.ldf' for database 'cf_pbtf' in sys.database_files. The file either does not exist, or was dropped.

X: partition is where the file is and space is maxed out.

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gtrapp

ASKER

Thanks, that worked.

gtrapp

ASKER

I need to adjust my maintenance plans to include the TRN files, so the Transcation Log file is kept small.

Guy Hengel [angelIII / a3]

>I need to adjust my maintenance plans to include the TRN files, so the Transcation Log file is kept small.
yes, exactly :)