Keith Tate (1/14/2014)

---

I'm not sure what is being asked now? There is no default password that I know of for every instance. I'm also not sure how strong the password...

Well, if Master Bob is stumped, how can we help?? :-P:w00t:

What about using something like the Process Monitor from Sysinternals to see if anything else launches after the tool reads...

We have build lists here as well: http://www.sqlservercentral.com/articles/Build+List/71065/

Basically I think you need custom scripts that run as part of your restore process to clean up the data before people use it. Essentially follow this:

- restore db

- set...

Sean Lange (1/14/2014)

---

Here is a true story from the field that a buddy of mine shared with me yesterday.

Or...

Ahh, Putty. I have that in mind whenever...

Fair enough. I've edited it to say T-SQL Backup command.

I'll award back points since this one was iffy.

EdVassie (1/14/2014)

---

A sabbatical is about taking time out of your normal routine to do something productive that you could not normally do.

I think you are starting well, putting...

There's a strategy, but it isn't backup and...

Viv Fletcher (1/14/2014)

---

The problem with "many hats" is that you become a jack-of-all-trades-master-of-none. There are too many areas in today's IT world for anybody to cover in any depth...

I'm hoping to get back to SQLBits this year, but with surgery coming, timing will matter. I hope they announce something soon.

Replication works with any recovery model. The issue is that the log cannot clear until the changes are out to the subscriber. This means that your simple mode db log...

below86 (1/13/2014)

---

I've thought about propping everything up on boxes to try it. I just know now that I can see over the cubicle walls when I stand and I'm...

djackson 22568 (1/13/2014)

---

I fear this will sound like I am opposed to something like this, but that is not my intention. I am sure there are places it would...

Nelson Petersen (1/10/2014)

---

Is this a time of dramatically fewer interruptions allowing focussed effort on a "project" or is it a sabbatical?

If it really is a sabbatical, you could start with...