Transaction Log

[funcrecall12]

Hi .

I need to shrink the transction log.
Currently, My datafile size is 5 GB and my log file is 45 GB, I want to shink it. What is the best approach in doing doing?

Thanks

 

[AtomicWedgie]

There are many ways, here are some usefull links I found on another forum:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1uzr.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_7vaf.asp

You might even want to take a look at the recovery model of your database.

Regards,

Atomic Wedgie

 

[SQLSister]

Read this FAQ

Shrinking Databases and Logs - SQL 7 and Higher
faq183-1534



Questions about posting. See faq183-874

 

[nigelrivett]

http://www.nigelrivett.net/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.