Torsleff-Experten
asked on
Large Transaction log files
Hi Experts,
I got a Project server solution where some of the databases has a large transaction log files:
I manually made a full backup of all the databases (shouldent that schrink the Transaction log files?)
etc. the ProjectServer_Draft = 1.967.300 kb and the ProjectServer_Draft_Log = 61.152.320 kb.
When the log file did not schrink when backing up the database, how do i then schrink the log file?
Best regards
Torsleff
I got a Project server solution where some of the databases has a large transaction log files:
I manually made a full backup of all the databases (shouldent that schrink the Transaction log files?)
etc. the ProjectServer_Draft = 1.967.300 kb and the ProjectServer_Draft_Log = 61.152.320 kb.
When the log file did not schrink when backing up the database, how do i then schrink the log file?
Best regards
Torsleff
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, but only if you change recovery to simple like I explained above. Otherwise the Log file will just continue to grow. If you do a nightly backup on the database and are not worried about a partial days worth of transactions you should be just fine to do the simple recovery model.
ASKER
ok ewanqoya,
i will set it to simple, when i have a full backup i will not risk anything by schrinking the log file?
even if i schrink it to the minimum size?
i will set it to simple, when i have a full backup i will not risk anything by schrinking the log file?
even if i schrink it to the minimum size?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No you will not risk anything, if you have a full backup. The only thing the log file is for is incase your server crashes mid day and you want to restore transactions that took place since the last database backup.
ASKER
ok, taking a db with simple recoverymode offline will schrink it to the minimumt? nice..
simple mode is fine with a full backup once or twice a day is ok.
simple mode is fine with a full backup once or twice a day is ok.
YEP, I do it on our SQL databases and just have them backup each night.
How is it going?
ASKER