I am trying to set up some party for SSC and the Exceptional DBA awards. PASS did come back and start to negotiate again, but then disappeared.

We should have...

Ninja's_RGR'us (6/29/2011)

---

So where's the line?

Let's say that I install 8 instances of sql express on a server with 8 cpus & 12 GB of ram so that they can all...

Ninja's_RGR'us (6/29/2011)

---

@steve-2, read the original question again. He is using the server to hold ±2 years of data in the main app for reporting reasons.

He's about to blow over...

Here, here, no linked servers. Way to fragile.

At least have each server collect and store it's own info, then roll it up.

First, please don't take MVP advice as legal or official in any way. We are people just like the rest of you, and are awarded the designation strictly because we...

Look back at Tom's solution.

If you don't understand that, and can't figure it out, post a specific question. It's not hard.

http://msdn.microsoft.com/en-us/library/ms178534.aspx

Search backup in our scripts section. There are lots of examples that do exactly what you are looking for.

You sound like you have a good handle on the situation. If it's limited tables (and for a limited time), replication should work. If it's all tables, might overkill, but...

LOL, haven't seen that. I have seen people w/ only 30 minutes of stuff, which is...

Jack Corbett (6/29/2011)

---

Steve Jones - SSC Editor (6/28/2011)

---

Enjoy presenting. Couple things.

1. Breathe. Easy to race through things. Take a moment at a few spots to get a drink of water...

This has been corrected. Thanks for the note.

Saw "no" in the article, thought "no", got "no" in the explanation and then ticked the wrong box to mark the correct answer. Some days I think I should have...

You are welcome to tackle it. No one has responded or submitted yet.

However please tackle one article at at time. IF you want this one respond here and leave a...

In that case, it sounds like you have a reporting environment and you're testing there sometimes, building a dev environment others?

Why not just separate those out? Resource constraints?

Replication will get...