I have a SharePoint content database with the size 70GB but he log file is 450GB. i wanted to shrink the log file. Can anyone tell me how to do that ? It would be great if anyone can provide me the complete flow.
- Do I have to shink the log file when the database is offline?
- what if we just take the backup and create a new log file ?
- How do we restrict the size of the log file by not growing big but just auto shrink by it self.
This is all on the production server, i need to fix this asap. Any help would be appreciated.
Thanks in Advance.
View Complete Post