On the list. It's a surprising amount of development work, so it hasn't been a priority. I have been thinking of these options:

- immediate

- never

- every hour

- every day

For the...

A couple things:

First, you might want to use .data, and not .query (that returns XML).

Second, XML is case sensitive, so "posttime" will not work. "PostTime" is needed.

Not entirely sure where...

Is Server C a SQL Server? If so, use a maintenance plan to delete old backup files. Very simple.

If not, then you can search on this site for "delete old...

Brandie Tarvin (7/23/2012)

---

Hey, guys. I am getting absolutely no response on the fundraising for the wildfire & flood victims. Any suggestions on how I can sweeten the pot to get...

Nope, just passed on all mine. No scores.

I'm probably being optimistic. Hopefully I'm wrong.

As mentioned functions are a bad idea. Code reuse in SQL Server doesn't work very well.

If you show some code and DDL, we may be able to help rewrite...

Are they going to the same I/O system?

We really need the entire error message, as noted above. 53 is generic, but there should be something with it to explain things.

Are you sure that your client is connecting...

I've never seen CESH written. Knowing the URL would help.

The Stairways are a great way to learn about particular topics.

Your question about learning SQL Server is more like "how do I learn about government" than "how do I learn...

You can also use the tools from Sysinternals to find out if the file has a lock on it.

jeff.mason (7/20/2012)

---

Steve Jones - SSC Editor (7/20/2012)

---

There was a slight typo in the original question, and I mistakenly added another in fixing it. It should have been:

12:10 AM - Transaction...

Perhaps not. Replication can work, but it's a lot of administrative overhead. AlwaysOn is easier to administer, but $$. Depends on your resources.

If you want to go to the cloud,...

krystian (7/20/2012)

---

The question was which transaction changes will be contain in the full backup?

In my understanding all transaction changes until the point where backup finish are recorded in the backup...