winslet (2/10/2010)

---

Just an add:

If you are trying to move only the backup files/folders you can use ROBOCOPY tool or simply you can use XCOPY from command prompt. Which move faster...

RBarryYoung (2/10/2010)

---

Lynn Pettis (2/10/2010)

---

RBarryYoung (2/10/2010)

---

Lynn Pettis (2/10/2010)

---

Any tips on trying to debug why a SB activated stored proc doesn't do everything it is supposed to but when run in debug...

CirquedeSQLeil (2/10/2010)

---

Now that opens up an entirely new can of worms.

Ideally...

Sounds reasonable. Curious, are the backups to local drives (DA or SAN) or to a network share?

$3cur1ty (2/10/2010)

---

Best bet would be a SAN mirror or use third party utilities (i.e. Double Take) - mirror the drive you're doing you backups on, at the block level with...

RBarryYoung (2/10/2010)

---

Lynn Pettis (2/10/2010)

---

Any tips on trying to debug why a SB activated stored proc doesn't do everything it is supposed to but when run in debug mode from SSMS...

Any tips on trying to debug why a SB activated stored proc doesn't do everything it is supposed to but when run in debug mode from SSMS it runs correctly?

At...

I have learned a lot about database mirroring in the last couple of weeks, and I know I have only scratched the surface. There is a lot more to...

Have similar issues here at times. Cut and paste to a text editor, save as a .txt file and then upload the file to SSC.

krypto69 (2/10/2010)

---

When I run the restore part -

I get an error

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'MSPHXX_ARC'.

Msg 319, Level 15, State 1, Line 4

Incorrect syntax near...

jcrawf02 (2/10/2010)

---

Lynn Pettis (2/10/2010)

---

Haven't seen that movie yet, but I have enjoyed the series Dollhouse. Too bad it is ending (or should I say...

Dropping the indexes may get blocked, as will the truncate table. All you can do at this point is wait for the rollback to complete.

Haven't seen that movie yet, but I have enjoyed the series Dollhouse. Too bad it is ending (or should I say ended) early.

George and Roy, as long as he plays by my rules, I'll help him. He has to show me what he is doing before I give him anything. ...

They might if they were a doll.