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 |
|
muzzettemm
Posting Yak Master
212 Posts |
 Posted - 2008-12-19 : 07:07:02
|
| I have a silly question, concerning backups I know there is backuping up of the Transaction logs is there also truncating of the transaction logs?? |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-12-19 : 08:03:58
|
| is that not Backup Log [name] ....with truncate_only |
 |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2008-12-19 : 12:58:09
|
| yes I'm sorry I should have said Truncate_only |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2008-12-19 : 14:46:46
|
| Well our IT guys had a situation where the Transaction Log was Huge and we were quckly runing out of space. Now since we are operating on a low budget getting more hardware is just not an option for us. He was doing full backups every 4 hours. Now he tried to do a shrink file but got error messages |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-19 : 16:48:40
|
quote:
Originally posted by muzzettemm
Well our IT guys had a situation where the Transaction Log was Huge and we were quckly runing out of space. Now since we are operating on a low budget getting more hardware is just not an option for us. He was doing full backups every 4 hours. Now he tried to do a shrink file but got error messages
There is no reason to do full backup every 4hours. Tell your It guys to read about types of backups in Booksonline carefully. You should backup log frequently to minimize log growth.If your company doesn't care about point in time recovery then switch your db toSimple recovery model. |
|
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2008-12-19 : 18:06:04
|
| for our database there isnt someone constantly entering data, I would say that they are updated 3 to 4 times a week 2 to 3 hours a day (rough estimate) there isnt any heavy duty data entry on a regular basis |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-20 : 09:39:51
|
quote:
Originally posted by muzzettemm
for our database there isnt someone constantly entering data, I would say that they are updated 3 to 4 times a week 2 to 3 hours a day (rough estimate) there isnt any heavy duty data entry on a regular basis
Then you can go with simple recovery model taking advantages of full and diff backup.Otherwise if you want to stay in full recovery model make sure to backup log frequently. |
|
|
|
|
|
|
Backups