Now how does that go?? Oh yes, Mr. Pettis is my dad, I'm Lynn. 😉

Your welcome, and if you need more help as you work through...

sjsubscribe (3/16/2010)

---

Steve Jones - Editor (3/16/2010)

---

I've actually had to tell a VP to "go away" when I was managing. It was bad enough that I would go in to check...

Yes, you would use the EXECUTE PROCESS Task to run gzip to uncompress the file.

jpSQLDude (3/16/2010)

---

Lynn Pettis (3/16/2010)

---

Don't delete that t-log backup file created at 1:05. It is fine. If you should need to restore that database to 1:03, you will need...

Paul White (3/16/2010)

---

I see. I write a fair number of cursors, usually for drip-feeding...

Mark D Powell (3/16/2010)

---

Lynn, after a restore of a database in full backup mode the database reflects both the contents of the database and the transactions recovered from the log...

Paul White (3/16/2010)

---

Lynn Pettis (3/16/2010)

---

The only problem was the time it took to rewrite dynamic sql. Getting all the single quotes (') right is a RPITB, but once done,...

jpSQLDude (3/16/2010)

---

I haven't forgotten this thread, and I am STILL working on this (I will know everything there is to know about SQL backups very soon!)

One other really funky thing...

Paul White (3/16/2010)

---

LOL. You should have edited your previous post...

Mark D Powell (3/16/2010)

---

I will disagree with the official answer because the question did not ask if the transaction was included in the backup file but rather asked if the...

Would you mind explaining further what you are looking for? Your question is a little vague.

Grant Fritchey (3/16/2010)

---

And I've apologized for that...

Grant Fritchey (3/16/2010)

---

I agree, the best skill you can begin to develop immediately is the ability to do a search. Remember, you're not the first person down this path. Actually,...

I wanted the 10,000th post to...

I am trying to finish up 2 articles for Grant and the Standard. Somehow life and work keep getting in the way.