after 6 months retired I got drawn back by a post to an old thread (still get alerts). Lots of changes to the site I see, but the basics are...

another option would be to add - another option would be to add - and recovery_model_desc != 'simple'

saves the 'or'

Lynn Pettis (10/10/2016)

---

Okay. Never did this...

lynn,

yes it can, in configuration manager under tcp/ip network protocols, list both separated by a comma.

right, back to the cooking and golf.

to prove I'm still loitering...........

humbled by all the well wishers, its appreciated.

cheers

george

Lynn Pettis (10/5/2016)

---

george sibbald (10/5/2016)

---

well that's me done. I retire today so this will be my last post.

I made it into the top 30 posters at one point so I...

well that's me done. I retire today so this will be my last post.

I made it into the top 30 posters at one point so I did my bit.

Enjoy the...

not used it myself but wondering if dacpac will help here

https://msdn.microsoft.com/en-gb/library/ee210546(v=sql.110).aspx

right click database, tasks, extract data-tier application

This is important, you should create the log small (64mb) initially, then grow it to the size...

once your planning and design is done I would say the elapsed time and therefore effort to get up and working end to end would be, quickest to longest -

logshipping

mirroring

alwayson

the...

check the sql errorlog and eventvwr logs on the witness. You can get this error if the sql service account has not been granted connect permission on the mirroring endpoint.

Also...

the SP3 patch can also be removed via add\remove programs

basically, yes. Install SP3 followed by the GDR version of MS15-058, to go to version 10.50.6220

+1 on health checking your servers looking for performance improvements in both code and the maintenance being done on the SQL instances, are there indexes that need work more frequently...

did you right click on setup.exe and select 'run as administrator' ?