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 |
|
loknathmahato
Starting Member
27 Posts |
 Posted - 2011-12-12 : 15:01:33
|
| Hi Friends,I have implemented Log shipping on my MS SQL server 2008 database but at the weekend i am facing a major issue regarding log file. At the end of the week when we do maintenance of our database we have to perform major deletion on our database due to that log file size grow up to 20 GB thereafter we perform re-indexing then the size grow up to 25 GB or more. That is not affordable because if we go with this size then next week we perform same thing then the log file size would be double.So can somebody suggest me that what i have to do?Can i shrink the database?Will shrink affect the Log shipping?My average MDF file size is within 15 GB .Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Database Shrinking Issue