Wayne West (10/21/2010)

---

Gail definitely rocks, I met her at PASS a couple of years ago and attended one of her panels.

And doing file names with embedded date is so massively...

Gail - you ROCK!

I put together scripts for Transaction log and diff db backups. They run fine when I execute them manually in SQL. However, the SQL agent jobs that I...

pavan_srirangam (10/19/2010)

---

you are in aright track.

But it would be better if you take differential every one hour and and set up clean up task to delete old differential backups so...

Yes, I meant thank you Wayne.

Thank you Eights and GilaMonster. Now I understand - never considered the down time to restore...........have been fortunate, SO FAR. This is definitely something that I need to...

Wayne West (10/19/2010)

---

If you need 24/7 uptime with a database of that size, you should definitely explore mirroring nd other high availability techniques. Do you have a server with...

Couple of comments:

1.The transaction log backups should be set to run every 15 minutes, 24x7. People often forget about important processes, like reindexing that are scheduled to run overnight, so...

Thanks for the great explanations everyone. I am beginning to put it all together now, but this raises more questions for my particular environment.

My call center enters sales orders...

Of course, the restore dialog makes this very easy to do whichever way you go and automaticaly selects and restores the appropriate logs, in my experience it's a lot faster...

Tom.Thomson (9/21/2010)

---

SkyBox (9/20/2010)

---

I considered using the Maint plan wizard, but couldn't decide if I should use the append vs. overwrite option. What am I missing here? I did...

Tom.Thomson (9/20/2010)

---

There's a problem with the backup script you posted if you intend to backup the log every 15 minutes: the name you generate will be the same for all...

GilaMonster (9/20/2010)

---

Now that the log is being backed up properly, you can do a once-off shrink

and drop it down to a reasonable size. DO NOT shrink it to 0....

So after backing up the trans log,...

Craig Farrell (9/19/2010)

---

Gail *may* have gone to bed already, she's across the pond, so I'll try to help in the meanwhile until she can bring her expertise back to bear....