Are you appending each backup to the same file? If so, I would change that. Each backup should go to its own file. Currently you will lose...

SQLKnowItAll (9/6/2012)

---

Did you guys (and gals) notice the original question and poorly written table structure? I think this is a state reference table with 50 entries. I'd just manually redo...

Doesn't quite work... :w00t:

SQLRNNR (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

Jan Van der Eecken (9/6/2012)

---

RBarryYoung (9/6/2012)

---

Stefan Krzywicki (9/5/2012)

---

"Root"...

Jan Van der Eecken (9/6/2012)

---

RBarryYoung (9/6/2012)

---

Stefan Krzywicki (9/5/2012)

---

"Root" is the proper...

tikoti (9/6/2012)

---

Robocopy is the tool I used to move backup files to a network location at a previous employer. I had it setup to move the files automatically upon...

Brandie! Where are my cookies? I could really use them. The obnoxious one is just spending way too much time here now a days. It's taking...

Richard Warr (9/6/2012)

---

Approach can also depend on whether this is a one-off repair or something that needs to happen on a regular basis. It's also wise to avoid the following...

John Hanrahan (9/6/2012)

---

Scott I definitely agree that it's the coder's responsibility. I managed a group of 8-12 programmers for a few years and we used agile practices but we...

tikoti (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

Backups to UNC locations can work, however small network hiccups can cause them to fail. What you may need to do is backup locally then move...

Not at all. The people writing the code are responsible for what they write, but they also have to answer to management. If management doesn't give them the...

ScottPletcher (9/6/2012)

---

Interesting....

sunny.tjk (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

sunny.tjk (9/6/2012)

---

I'll be sending the execution plan in a bit.

I've a question, I ran the following query and when I looked at the execution plan it's just...

John Hanrahan (9/6/2012)

---

I laugh and laugh. Agile often means (to the managers in charge) get it done and skip whatever you think you can. That may not be...

Backups to UNC locations can work, however small network hiccups can cause them to fail. What you may need to do is backup locally then move the backup file...