My guess is that you need to learn more about how AlwaysOn Ags work, as well as brush up on any mirroring/logshipping/replication/clustering stuff you don't know well

Sorry to hear that and good luck in the future.

Do you have the report that shows which areas you were weak in? I might start there, reviewing those requirements and...

Meow Now (10/27/2014)

---

Developers love to push CI since it's simple and makes sense with application code. It's a whole new beast when you're trying to automate deployment of a terabyte...

jaime.simancas 27970 (10/24/2014)

---

I read somewhere that 80% of "employees", who have the position of "management" should not be there. I have to think that most of these managers are...

Meow Now (10/22/2014)

---

Oh, and thanks for all the hard work Steve & Co. This site saved me nearly a decade ago when I suddenly inherited my first DBA position and...

What Perry said.

Windows name unique. SQL instance names unique on a host.

Kansas City had some great BBQ when I was there for SQL Sat. They did a mini BBQ crawl on Friday, hitting a few places.

Excellent, and I'm sure I gained...

Jeff Moden (10/22/2014)

---

Steve,

After a fairly long wait (> 30 seconds), I got the following...

Sorry, an error has occurred

If problems persist, please contact us to let us know.

When reporting this error,...

Ed Wagner (10/22/2014)

---

I whole heartedly agree. Steve is the major driving force behind SSC and a big part of why I've called SSC "home" for more than a decade....

Correct, as Gail mentioned, no script generation, or at least, not in one stage.

Here's what I'd do.

Set up the restore in the GUI, moving paths/folders as needed. Don't click "OK",...

spaghettidba (10/21/2014)

---

rodjkidd (10/21/2014)

---

I want to go to at least one SQL Sat in Italy. November is probably a no go due to going to PASS, and December is so full...

Gail is correct, you need to restore things as they were. You can move drives/folders, but not files.

Is this a one time thing or do you do this often? If...

Create a table with a varchar of 1500 (or more) in length. You can insert with BULK INSERT or SSIS (or the import wizard). Map each line, no delimeter, to...

I'm with Gail. Two parameters. At some point you may refactor this and you'll want the separation.

spaghettidba (10/21/2014)

---

Jack Corbett (10/21/2014)

---

I think there are fewer overall posts and most of the posts are by people who have very little understanding of or experience with SQL...