Backing up to a network location is not recommended. If you need to move backups to another server/PC you should do so with a file copy AFTER the backup...

Ol'SureHand (8/3/2009)

---

Jeff Moden (9/13/2008)

---

Jack Corbett (9/13/2008)

---

[Jack said:] [ANSI_PADDING] is turned off by default at the Database level, which is odd considering the ability to turn it off is going to...

Lynn Pettis (8/2/2009)

---

Thought I'd bring this to the water cooler. We talked to Kassondra again today, and she leaves reception tomorrow to actually start Basic Training. She sounded...

This KB Article isn't your exact problem, but does appear to be a similar one so you might want to try the suggestions.

You should also read this blog post by...

GilaMonster (8/2/2009)

---

Jack Corbett (8/1/2009)

---

Although I'm not quite as well-versed in dealing with corruption issues as you are I'll make sure I check in there at least once a day for...

It would be helpful if you posted using the methods suggested in the 1st article linked in my signature line. It helps us understand your problem better and provide...

Jeff Moden (8/1/2009)

---

I did just exactly that. I'm...

GilaMonster (8/1/2009)

---

Well I'm off to TechEd tomorrow and looking at the schedule I have, I doubt I'm going to be able to post here much during the next 4 days....

Thanks Jeff. Those are actually reasons why the SQL 7 application is still out there. I didn't want to mess with it while I was there and I...

I provided an answer, maybe not...

If you are using control of flow statements (IF, ELSE, WHILE) and you have more than one command in the block you need to use BEGIN and END.

If I were...

This is why I asked. I didn't even think about it from a DR/Backups perspective. Backups would definitely have to be local and then copied at completion to...

Hey I just posted a question about determining what you can consolidate, http://www.sqlservercentral.com/Forums/Topic763323-1550-1.aspx. Gus has already chimed in and interested in what others think/do/have done.

Ah, yes, but do you have any specific counters or methods you would use for checking load? Here's what I gave them to start: