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 |
|
briankind
Starting Member
17 Posts |
 Posted - 2009-07-25 : 02:03:08
|
| fulldifferentiallogs transactionalwhat is the difference between differential vs logs transactional?why do we need it?can you just set up one full everyday? is this good?beginnerBrian |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-25 : 04:27:28
|
| One full every day's fine for a dev system where the DB is in Simple recovery and there's no worries about losing a day's data if the database fails. For a production database that may have rules about exactly how little data may be lost (10 min, 1 hour), you generally need full recovery model and frequent log backups to do point in time recovery.Start by reading Books Online (the SQL help file) on backups and recovery models.Also, you can read this: [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-25 : 20:55:51
|
| Similar post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=130026 |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-07-27 : 13:41:20
|
| what is the difference between differential vs logs transactional?Full backups creates a stand-alone image of the entire database.A differential backup backs up only modified extents since the last complete backupA transaction log backup backs up all transactions since either the previous transaction log backup, or the complete database backup if there have been no transaction log backups performed for the database in the past.why do we need it?Backups are used for disaster recovery plan. Using a Transaction Log backup allows you to perform point-in-time restores, so using a Transaction Log backup allows you to restore your database to any particular date and time that the Transaction Log backup covers |
|
|
|
|
|
|
basic back up and recovery concept?