Message
From
30/07/2003 08:32:04
To
29/07/2003 19:02:14
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Miscellaneous
Thread ID:
00814762
Message ID:
00814863
Views:
16
You can use the DBCC SHRINKFILE() command to reduce the physical size of the transaction log.
Before doing so, you need to determine why your transaction log is so large? Are you doing periodic transaction log backups? Maybe you're doing large data loads?
-Mike
>Transaction log is very big as it is taking tens of giga bytes of space. How can I reduce the size?
>
>Thanks
>Bharat
Before doing so, you need to determine why your transaction log is so large? Are you doing periodic transaction log backups? Maybe you're doing large data loads?
-Mike
>Transaction log is very big as it is taking tens of giga bytes of space. How can I reduce the size?
>
>Thanks
>Bharat