THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Jorg Klein

Microsoft Data Platform MVP from the Netherlands

BI on your terms with SQL Server 2016

You can read this blog post at this link: https://jorgklein.com/2015/05/07/bi-on-your-terms-with-sql-server-2016

This blog has moved to www.jorgklein.com There will be no further posts on sqlblog.com. Please update your feeds accordingly.

You can follow me on twitter: http://twitter.com/jorg__klein

Published Friday, May 22, 2015 4:07 PM by jorg

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Marimuthu said:

MSDB database in Always On Availability Group: This makes your SQL Agent Jobs that execute your SSIS packages High Available (already possible in SQL 2014)

 -- Could you please throw some more light on MSDB on AlwaysOn AG. i.e.,how to configure msdb on AlwaysON AG .. Please give the step by step details ...

Thanks in advance

May 24, 2015 5:34 AM
 

Nacho Alonso Portillo said:

Hi Marimuthu,

Actually, you cannot replicate any of the system databases, including MSDB. Any attempt to do so fails with error 35249 "An attempt to add or join a system database, '%.*ls', to an availability group failed. Specify only user databases for this operation." And the rule evaluated triggers the error and prevents the action on any database whose database_id is 1 (master), 2 (tempdb), 3 (model) or 4 (msdb.)

Thanks,

Nacho

http://blogs.msdn.com/ialonso

May 25, 2015 7:40 AM
 

jorg said:

Hi Nacho,

I recently attended a session from a SQL Server MVP about SQL 2014 and he told me adding the MSDB to an AlwaysOn Group should be possible from SQL 2014. I had some contact with him about this matter and he told me this was probably in a CTP version of SQL 2014 because it is indeed not possible anymore in SQL 2014 today.

So you are right Nacho, thanks for letting us know, I have edited the blog post.

Regards,

Jorg

June 3, 2015 7:42 AM

Leave a Comment

(required) 
(required) 
Submit

About jorg

Jorg Klein, Microsoft Data Platform MVP from the Netherlands.
Privacy Statement