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.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-09-25 : 05:59:41
|
| Dear MemberPlease tell me what is process of shrinkfile ldf file in sql2008 or How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2008thnaks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2010-09-28 : 02:26:46
|
| my recovery model is fullmy database size is 11 GBldf file size of my database is near about 4 GBi have give a log backup to every 1 hour this the log file size are near about 700 to 900 mb and i think it is very highso i have shrink ldf file to minimize size. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
DBCC SHRINKFILE in sql2008