Hello,
I just went through the process of shrinking the database transaction log file. It worked like a charm - Thank you VERY much.
I know it's been a while, but I have a few small questions:
1) how should I schedule transaction logs to be backed up - my database is accessed/updated VERY frequetnly, so I was thinking about backing up the log about every 30 - 45 minutes.
2) How do I keep the transaction log on the SQL server small like it is now? Does backing up the transaction log more frequently keep sizes small? Should I restrict the file growth of the transaction log to a specific size in the database properties?
The main reason my log file is growing so quickly is because I'm trying to run a DBCC REINDEX on my largest table, which has never been done. How can I run that reindex if it keeps growing my log file to insane sizes???
Hopefully someone's still around to read, and help me with this situation. If so - thanks in advance!
