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 |
|
stewart05
Starting Member
15 Posts |
 Posted - 2008-10-16 : 18:11:54
|
| Ok, so I'm still very very new (and green) to SQL. I have a backup program that gives me options to backup my SQL db's and I'm trying to figure out the best way to them up.These db's are for point of sale computers (computerized cash registers) for liquor stores, or bicycle shops, or restaurants. My backup software allows for full backups, differential, and transaction logs. I'm trying to figure out which to do.I'm thinking I should do a monthly or weekly full, then do differential, or transaction log in between, but what is better? Should I do the logs or differential?Some of the db's are set for simple recovery model and in that mode I couldn't backup the transaction logs, but I understand that I can change the db to Full recovery model. So what should I do?? What is the pros/cons of doing either or??Thanks guys!!!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-16 : 18:34:02
|
| It depends on how critical your databases are. If your DB is on simple recovery model, then you can't have point of time recovery. Depending on necessity of data recovery, you can set the recovery model.1) Read about Recovery model in booksonline(This is required to understand backup strategy)2) We do Full backup everyday and Transaction Log backup every 20 mins if database is less than 100GB3)We do Full backup every week ,differential every day and tran log every 20 mins if DB>100GB. |
 |
|
|
stewart05
Starting Member
15 Posts |
Posted - 2008-10-16 : 20:25:29
|
| First, I must be a tool, but where are the books online?? I can't seem to find them, but have seem them referenced a lot.Well, I'm looking for only daily backups weather differential or tranaction logs, and then fulls maybe every week... maybe. Thats what I don't really know.What I'm doing is I'm going to be offering an offsite remote backup solution for these databases. So every night, they will backup via the internet to my server.These databases are small. Maybe 1gb at the most, but I'm still wanting to conserve bandwidth and disk space on my server.These dbs don't need 20min log backups, as they are not used "that" much. So I'm just trying to firgure out if I need to worry about backing up the transaction logs or just do a differential backup.On a side note, if any of you guys are looking for a kickass remote backup solution that you get to host yourself and backs up SQL let me know I've found a pretty sweet one!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Backup questions