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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2003-12-02 : 14:00:46
|
| OK,I've read through a lot of threads from a search, and didn't see it.Our stndard set up here is to dump the db everynight, move it to contingency, restore it. Then every 15 minutes dump and copy the tranny and apply it...Simple effective no worries (avg dbs between 2 and 4 gb)Now this rocket scientest project is doing log shipping. Box was rebuilt, logs are shipped every hour...no mention of a full dump, so I made the prod dba dump it every nght anyway.Now the questionWhat happens if contingency corrupts?Does that mean that the intial dump has to be restored and every tranny (hopefully they're not being deleted) has to be applied...since the box was built (let's see 3 months * 30 day avg * 24 trannies a day)?Is that right?Or can I use the nightly that I started having him take?My first exposure to enterprise..Brett8-) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-02 : 14:06:36
|
| Yes you can use the nightly and then restore the transaction logs after the nightly. But this is independent of log shipping and Enterprise Edition. That's just how restores work. Without the nightly, you would have to find the newest backup and restore ALL of the transaction logs since then.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-02 : 14:32:41
|
quote:
Originally posted by tduggan
Yes you can use the nightly and then restore the transaction logs after the nightly. But this is independent of log shipping and Enterprise Edition. That's just how restores work. Without the nightly, you would have to find the newest backup and restore ALL of the transaction logs since then.Tara
idiots...I'm glad I asked him to start....and they get PAID!Brett8-) |
|
|
|
|
|
|
Another log shipping question