Re: SQL Server Transaction Log
From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 02/22/04
- Next message: Hassan: "deadlock errors 1204 and 1205 differences"
- Previous message: Anith Sen: "Re: Saving grid results to file"
- In reply to: Yusuf Pachorawala: "SQL Server Transaction Log"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 22 Feb 2004 01:09:53 -0500
USE MASTER
GO
BACKUP LOG databasename WITH TRUNCATE_ONLY
USE databasename
GO
-- get database_log_filename from EXEC sp_helpfile
DBCC SHRINKFILE(database_log_filename, 1)
Also see http://www.aspfaq.com/2471 and http://www.aspfaq.com/2446 (the
latter was written with tempdb in mind, but are applicable in general).
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/ "Yusuf Pachorawala" <yusufp@al-faris.com> wrote in message news:ODzD6cQ#DHA.340@tk2msftngp13.phx.gbl... > Dear Friends > > I am new to MS SQL server 2000 > > I am using a MS SQL server 2000 with SP3. The database file ext mdf is > around 800mb but the transaction log file ext ldf has beocme as big as 26.8 > gb. I have kept the recovery model to full as well as simple both , but in > either case after taking the backup the transaction log wotn truncate. I > have also tried the backup command from the query analyser with the > truncate_only option but no change in the log file size. > > Can anyone guide me how to truncate the log file? > regards > Yusuf > >
- Next message: Hassan: "deadlock errors 1204 and 1205 differences"
- Previous message: Anith Sen: "Re: Saving grid results to file"
- In reply to: Yusuf Pachorawala: "SQL Server Transaction Log"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
