I find Data Warehouse stuff interesting but I have very little exposure to it at the moment, like some of you. I can't tell if it would be better for...

Thanks. I can't see it on the official site, though?

https://www.microsoft.com/learning/en-gb/mcsa-sql-certification.aspx

Thanks, all. That's really helpful. I've got some reading to do but I'll report back when/if we implement this.

Yes, I think it's going to be a full-on project rather than a quick fix. Could be interesting though.

Damn, I did think it might be a bit too good to be true.

GilaMonster (9/3/2014)

---

I suppose you could set up a login that has CONTROL SERVER permissions and DENY SELECT...

According to your screenshots it should go into D:\LogShip\Backups\HIPUAE\Secondary, no?

I think one of the reasons you're not getting replies is that it's such a broad question. There's more than one type of DBA. For starters when you think about...

1. Yes, you can use 2014 Management Studio 2014 for older databases. I do it all the time. It's just not advisable the other way round.

2. Yes, I have 2012...

It's really hard to say from the outside. I asked things like what I could expect my first month in the role to involve, and that went down very well...

The error message tells you how to fix it, look. Do this.

jakeer.basha (9/2/2014)You must drop the current configuration by clearing the 'Enable this as a primary database in a log...

Can you show us your syntax?

That's not a lot of information to go on really. First things first; if you've upgraded to SQL 2014 (which I assume is what you mean) have you ensured that...

Another issue with log-shipping is that if you have the secondary database in standby mode so that it's readable, every time a log file is restored, any users will be...

This might just be me and my uptight British ways ;-), but I'm not going to disclose my salary. I'm pretty happy with it though.

From my fairly recent experience of...

Can you tell us what error message you're getting?