How to reduce the Physical Log size

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

How to reduce the Physical Log size

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-11 : 08:17:53

Farman writes "My log file size is 2.19 GB I want to reduce the log file size?
pls help me."

nr
SQLTeam MVY

12543 Posts

Posted - 2006-05-11 : 08:36:37

see
http://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Kristen
Test

22859 Posts

Posted - 2006-05-11 : 08:57:37

phanigopal
Starting Member

1 Post

Posted - 2006-05-11 : 09:25:40

quote:
Originally posted by AskSQLTeam

Farman writes "My log file size is 2.19 GB I want to reduce the log file size?
pls help me."

You can truncate the transaction log using

BACKUP LOG { database_name | @database_name_var }
{
[ WITH
{ TRUNCATE_ONLY } ]
}

and then issuing the dbcc command

DBCC SHRINKDATABASE (database name,target_percent,TRUNCATE ONLY)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources