Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Log won't truncate when backed up

Status
Not open for further replies.

ptheriault

IS-IT--Management
Joined
Aug 28, 2006
Messages
2,699
Location
US
I have a SQL server 2005 instance with a database that has a 13gb log file. I have created and run the following job to backup the log.

BACKUP LOG [1stComp] TO [FirstCompLogDump] WITH NOFORMAT, INIT, NAME = N'1stComp-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

I know this step will also init my backup device. For some reason the log is not truncating. Do I need to add the with truncate command?

I even tried DBCC SHRINKFILE(db_name, 500);

But I won't shrink. I should mention this database is the principal in of a mirror.
 
Never mind...It finally trunacted. I guess it had been so long that it had truncated it just took some time.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top