Thanks, that helped a lot!

I have set up a number of server-side traces.

I have included a little bit of the code below to help out the next person.

I need to...

Or under SSIS its a "namespace resolution operator":

..........Variables used in expressions must have unique names for the expression evaluator to evaluate the expression correctly. If a package uses multiple variables...

That definitely makes it clearer... but it certainly isn't clear!

Steve Jones - Editor (3/18/2010)

---

Don't be sorry. We appreciate the acknowledgement, but it's not necessary. we very much are here to help, and we enjoy it. Our intention is not...

GilaMonster (3/18/2010)

---

Yes. Switch the recovery model from full to simple and back to full.

That breaks the log chain. Log backups will fail from that point on until you run...

GilaMonster (3/16/2010)

---

Then there is a prior full backup somewhere. If there has never been a backup, attempting to take a log backup will fail. (fail as in give an error...

If you mean Fail as in not...

Brandie Tarvin (3/16/2010)

---

Is there a reason why that backup has offended you to the point that you must execute (or excommunicate) it on general principals?

In all things with SQL...

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 it...

homebrew01 (3/16/2010)

---

How do you come to this conclusion ? You've got a Full from Monday, Diff from Tuesday mornig, and logs since then. Why did you run another full...

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 I...

Thank you very much for all your helpful responses, I really appreciate it!

I will tell you what I have currently set up -- maybe you will have some feedback... maybe...

RBarryYoung (2/22/2010)

---

This is a SQL 2008 forum, NOT SQL 2000. Please clarify what version of SQL Server you have.

Also, DTS is pretty awful, the only reason to use it...

AndrewSQLDBA (2/22/2010)

---

I never use a third party tool when working with SQL Server, it can just about anything, and it can sure handle copying a file across the network to...

AndrewSQLDBA (2/22/2010)

---

SQL DTS is very simple, and you use VBSCript as your coding language. All you have to do to create a function to move a file or delete a...