'How to minimize transaction log sqlserver database .?
I have database size is more than 125 GB . and every 1 hour the database is not respond . the message is every time say (The transaction log for database MESP_2015 is full) . i make some solutions but the problem is still .
- I change hard drive to 1 TB .
- I set the backup every day one time automatically .
- I tried (SHRINKFILE) and recovery (log file and database). using sql command
- I add More log files to ease pressure on databases.
All this idea is not help me .
Can I Remove transaction and rebuild again or remove log file . see screen shot .
(source: al-mnar.com)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|