Markus (8/15/2011)

---

Yea, I wish we had the budget for new hardware. I would rather build all new servers and restore the databases to them and would have a fallback....

You're welcome. Let us know if you have any additional questions on this subject.

Or other subjects, which can be posted as other threads. @=)

Sqlsavy (8/15/2011)

---

sorry for the confusion. Log is growing on Principle server.

Is it possible to backup log on Principle server? will that not break the Mirror?

Because I thought in high-safety method...

Knowing the blocked query doesn't help you. Any query could be blocked. What you need to know is the details of the blocking query (the one that is stopping the...

Calm down. We're trying to help. Panic doesn't do anything for you but enable you to ignore what we're saying.

Yes, error logs cycle on their own without a restart. It's...

Kurt W. Zimmerman (8/12/2011)

---

Brandie Tarvin (8/12/2011)

---

What changed between the time it was providing results and the time it stopped?

Any OS service packs? Any SQL Server hot fixes / SPs? Any...

Kiara (8/15/2011)

---

SQL Kidd (8/12/2011)

I totally get you and agree with you! Let me be even more brutally honest with you. I loathe technology! At best my heart can be...

To ditto everything everyone else has been saying to you...

Two months to get a cert?? You do realize how many exams are involved in getting certification, right? It's not just...

And being totally snarky (forgive the humor during...

What changed between the time it was providing results and the time it stopped?

Any OS service packs? Any SQL Server hot fixes / SPs? Any major issues with your database(s)?

Is some other process going in and clearing off space from that location by deleting files it thinks are archived?

Are your older logs in the same location as the current...

To add a note on the current answers, REPLICATE() is a wonderful function. So is STUFF(), though STUFF() will actually replace an existing character, so be careful.

You can use them...

Another place to check is the usual assortment of certification books. They often have tutorials you can walk through yourself in how to use the various tools in SQL Server.

You're correct. The definition in BOL is pretty much identical, word for word, except for a final statement in the Insensitive part:

When ISO syntax is used, if INSENSITIVE is omitted,...

Ditto on the SSIS package. You can create it easily enough (aside from the learning curve), then schedule it with a job to run automatically.

If the other system is behind...