| Author |
Topic |
|
keithc
Starting Member
35 Posts |
 Posted - 2004-11-22 : 14:49:46
|
| Tara I need link to your website. I remember that you had a few maintenance plans for SQL that I can maybe use for our production SQL box. Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-11-22 : 16:25:28
|
| Have you looked at the webblog menu item on the site here?Brett8-) |
 |
|
|
keithc
Starting Member
35 Posts |
Posted - 2004-11-22 : 18:03:11
|
| Thanks X will do. Tara i used you backup scripts for DB's and Tlogs. I am confused as how to set Retention. Like I set retention for backups to be 7 days. I am unsure now based off the data file retenion how long I should set it for my Tran logs. The server currently is not doing alot of transactions but will be very loaded in near future. I want to base my backups on a server that has a good load on it so my logs don't get to crazy. Any suggestions? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-22 : 18:08:12
|
| Retention is for how many backup files you want to retain on disk. We use the same retention number for both backups and tlogs. Our retention policy is 2 days.Tara |
|
|
|
keithc
Starting Member
35 Posts |
Posted - 2004-11-22 : 18:18:39
|
| How often do you run the log/data backup procs? Do you set a certain schedule for the job to run the procedures? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-22 : 18:20:30
|
| I run full backups once per day and tlog backups every 15 minutes. These values might not be good for you, but due to the criticality of our data, we must backup often. It's pretty common to run tlogs every hour. It just depends on your business requirements.Tara |
|
|
|
keithc
Starting Member
35 Posts |
Posted - 2004-11-22 : 18:26:58
|
| Ok where I am confused is say I do a full backup every day and my logs backup say every 15 minutes, if I need to restore the Database to an earlier time in the day well am I correct in thinking I will only be able to use the 2 transaction log files created in the last half hour since retention is set at 2? I hope that made sense forgive me if it didn't I am not a DBA and very new still to sql. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-22 : 18:30:17
|
| If you need to do a restore at 10am and you've got a full backup at 9:55am and a tlog backup that has 9:45 til 10:15am, then restore the full backup at 9:55am and the tlog backup at 9:45am and issue the STOPAT option to stop at 10am.Retention is outside of this though. Retention has to do with keeping files on disk, not the ability to restore them. You should have these files on tape somewhere so if you need to go back farther, you can.Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-23 : 00:30:06
|
| "... since retention is set at 2"I think that refers to the number of days to retain files, not the number of files to retainKristen |
|
|
|
|
Ping Tara