FYI, once you have switched it to Full recovery model, you will need to take one full backup of your database first before you can implement log-shipping on it.

Thanks; I hope you're right. I'm very concerned that I'm getting de-skilled here. It's really sad; nobody cares, nobody wants to do anything well, nobody wants to improve anything. I...

Eric M Russell (1/28/2016)

---

On the flip side, as a job seeker you should also be suspicious of "opportunities" which seem to always be available. For example, there are some employers...

It looks as though ou need to install a CU: https://support.microsoft.com/en-us/kb/3093869

Edit: although that relates to 2012. Still, what patch level are you on?

Have you tried starting it with the -f switch? (sqlservr.exe -f;-s INSTANCENAME, I think it is.)

https://technet.microsoft.com/en-us/library/ms178067%28v=sql.105%29.aspx

2.) Is there anyway ( any command ) that will prevent stuff being written to the transaction log when we some user executes an update statement. Some of these updates...

Which db are you running it against?

Also, what kind of replication is it?

Yet Another DBA (12/15/2015)

---

Unfortunately too many companies see frequent job changes as detrimental. I cant remember which of the forums veterans it was who made the comment that a short...

I assume you got that from here?

http://www.trycatchfinally.net/2009/05/accessing-a-clustered-sql-server-instance-without-the-instance-name/

Could you just ask your networks people (or whoever does it) to open whichever port it is that you want to use?

It sounds a little over-complicated. I think you could get what you want just using AlwaysOn Availability Groups.

If you need to keep the instance name the same because you...

This topic has been at the forefront of my mind for a while now. I recently left a very interesting DBA role in a bleeding-edge DevOps environment* to come to...

I think (and somebody will no doubt correct me if I'm wrong) that you need to take that full backup again the first time because until you do, that database...

In your second datacentre, after you've restored the db, take another backup then try to add the database to the AG.

(Although it sounds as though you specifically don't want...

David Graham (12/9/2015)

---

SQL Server A: Has Primary Availability Group A with Database 1, Database 2, and Database 3. Has Secondary Availability Group B with Database 4, Database 5, and Database...

There are much easier ways to do a restore! I can't tell from your script, but are you trying to move the file onto itself? (The reason I ask is...