If...

Richard Driscoll (5/28/2009)

---

oh come on! How does N-Var-Char translate to this answer!

I hesitated to answer because none of the anwers seemed correct and when I finally did I was greeted...

Just a follow-up, how is your testing going?

john.arnott (5/28/2009)

---

I apologize for jumping in by posting a question on one of the echo threads that Gail shared. Didn't realize that consensus what that to leave it to Steve...

Steve Jones - Editor (5/28/2009)

---

I read that gem. Had to read it twice to be sure that I wasn't misreading things.

Shaking head here all the while. Some days I think...

Here is my suggestion, do your backup to a local directory, then move or copy the file to the other server. From what you posted, I couldn't tell you...

GSquared (5/28/2009)

---

Yes, you can run them at the same time in 2005. I've had some IO bottlenecks from concurrency in that case, but it's potentially not a big deal.

On...

We have a parrot on the site who is mimicing advice or giving really bad advice. For example, check...

Pardon me if you have already answered this, but which instance (or instances) of SQL Server are you unable to connect to remotely?

Anyone catch this little gem?

Pradyothana Shastry (5/27/2009)

---

Adding more disk space is one better option. If you want to keep dialy one day backup then better option is 'With copy_only' so that it will overwrite...

Here is the code you are going to need. Please note the clustered index created on the temporary table. This is required as it controls the order of...

T o o m u c h b e e r.

Wait, no such thing! I think we are all "floating" and have too much fun.

:w00t:

I like that!

Actually, since neither FULL BACKUPS or DIFFERENTIAL BACKUPS truncate the transaction log, and starting with SQL Server 2005 TRANSACTION LOG BACKUPS can run while FULL BACKUPS are running, I see...