Perry Whittle (12/14/2016)

---

Siberian Khatru (12/14/2016)

---

but in order to change the certificate on a database -- don't I need to un-encrypt it and then re-encrypt it with the new certificate? ...

Perry Whittle (12/14/2016)

---

Siberian Khatru (12/14/2016)

---

I have a new SQL Server 2014 instance that I need to import many older SQL 2012 databases to in an effort to refresh a development...

Jeff Moden (10/28/2016)

---

Siberian Khatru (10/28/2016)

---

Thanks all for the excellent advice and pointers. I am slowly altering all these databases to be of the SIMPLE recovery model and shrinking the...

Thanks all for the excellent advice and pointers. I am slowly altering all these databases to be of the SIMPLE recovery model and shrinking the LOG files to 50mb...

Jeff Moden (10/26/2016)

---

HanShi (10/26/2016)

---

Jeff Moden (10/26/2016)

---

p.s. As for ascertaining the recommended size for the log files, you could write a script to (for each DB)...

1. Set the SIMPLE...

Man, I gotta read the Managing Transaction Logs[/url] eBook! It's a complicated subject!

So if I understand things correctly, if I have these set to Simple mode, then the size of the trans log is really not all that important since we will...

Jeff Moden (10/26/2016)

---

Siberian Khatru (10/26/2016)I'm kind of torn here as to whether or not to bother other than to switch to SIMPLE. I would guess at this point that leaving...

Yes, I do realize that switching these all to SIMPLE will render point in time recovery as impossible. I made it a point to mention that to the proponents...

jasona.work (10/26/2016)

---

Siberian Khatru (10/26/2016)

---

As a bit of background, I've just been given charge of maintaining an existing (and thoroughly neglected) SharePoint database server. Having started regularly integrity checks, my...

I just went ahead and rolled the server during off hours...thanks though.

Steve Jones - SSC Editor (3/10/2016)

---

Glad it's working, but you should make sure the DAC works.

If you use SSMS and the ADMIN: trick, you likely need to be on the...

A appreciate all the replies and I've just gotten clear of this after one hellacious day. The DAC facility simply doesn't work in our clustered environment so I could...

spaghettidba (3/8/2016)

---

Not with SSMS. You can cange the connection of a query window, but the new connection will always be to a single server.

If you want to do that with...

Great content, other than the typos and nomenclature things others have already mentioned. Thanks!