February 1, 2011 at 3:04 pm
I run a Full backup on all databases on my SQL 2008 Server. I do this once a week.
My question is, should I be backing up the TransLogs too?
February 1, 2011 at 3:25 pm
Gail has published a wonderful article at ssc concerning your Q.
http://www.sqlservercentral.com/articles/64582/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 1, 2011 at 4:02 pm
odeonkreel (2/1/2011)
I run a Full backup on all databases on my SQL 2008 Server. I do this once a week.My question is, should I be backing up the TransLogs too?
It all depends... lets say your full backup was taken on Sunday then your system crashes on Friday.
Ask you this two questions in no particular order:
- How will business feel/react when they learn almost an entire week of data got lost?
- Woud you still have a job if such a thing happens?
You have to assess the criticality of each database and ask business how much data can be lost without major damage, depending on that you design your backup/recovery strategy which will lead to the type and frequence of the backups.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 1, 2011 at 4:15 pm
odeonkreel (2/1/2011)
I run a Full backup on all databases on my SQL 2008 Server. I do this once a week.My question is, should I be backing up the TransLogs too?
If you're not in simple recovery mode... yes.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 2, 2011 at 4:51 am
And, if you're only doing a full backup once a week, you might want to consider doing incremental backups nightly. Then you'll only have, at most 48 or so log backups to restore for a 24 hour period, assuming a 30 minute log backup rate.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2011 at 8:26 am
odeonkreel (2/1/2011)
I run a Full backup on all databases on my SQL 2008 Server. I do this once a week.My question is, should I be backing up the TransLogs too?
Full Backup on Day 0 --->Sunday
Tran Backup on Day 1 --->Monday
Tran Backup on Day 2 --->Tuesday
Tran Backup on Day 3 --->Wednesday
Tran Backup on Day 4 --->Thursday
Tran Backup on Day 5 --->Friday
Tran Backup on Day 6 --->Saturday
Tran Backup on Day 0 --->Sunday
Trans log need to be enabled for every 15 min
If your database has only Full backup on every week if there is a failure in the system you will not be able to restore the full data.data lose is high inyour case.
If you do the above type of process then you can recover your data until last Trans log.This type of process help you in recovering data at the point of failuer,this type of process is good habit so that you will not loose any data.
You can configure with differential backup also with trans log
Choose the type of backup which helps you in recovering the data.
Hope you would have get some idea on bakup
Thanks
Parthi
Thanks
Parthi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply