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 |
|
cornall
Posting Yak Master
148 Posts |
 Posted - 2008-10-28 : 08:05:51
|
| Hi,I am no DBA and we have a dept who are hanging onto a 500Gig transaction log as the claim they might need it!Now my understanding is that unless they back this log up it is quite useless.They take full weekly backups but never backup the transaction log or shrink it.I am I right in saying they might as well run the DB in simple mode?Cheers D |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-28 : 08:18:47
|
| 500 GB is too big in size.If they are not taking Trnsactional log backup , then you can change it to Simple Recovery model and shrink the log file. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-28 : 08:20:34
|
| But if they need point in time Recovery and data is critical, then you need to backup tran log frequently like every 15-30 mins. |
|
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2008-10-28 : 09:10:22
|
| I am happy for them to have backups of the transaction log. However they seem to think that by keeping the 500gig log file istself they can get a point in time recovery if things go wrong. I think that they need to take backups to recover to a point in time. If they want to reverse some transactions can the raw 500 gig log file be used? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-28 : 09:44:10
|
| They are completely wrong.You need to backup Transaction log frequently to recover point in time and by backing up log you are also managing log growth. |
|
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2008-10-28 : 11:32:46
|
| Cheers just wanted to double check before I argue this with them!! |
|
|
|
|
|
|
Keeping Transaction Logs