I would normally be inclined to agree, but it's happening on 2 different SANs (not interconnected), the SAN logs are clean and Windows doesn't seem to notice it

Hi John,

That's a scheduled full back we take daily at 8pm. It's a script I wrote that we use on all our SQL Server 2008R2 servers, clustered or not....

my guess would be you need to recover the rsreportserver.config file too

you need to provide a lot more information.

Service broker can do some things like this, but not all

here:

http://connect.microsoft.com/SQLServer/feedback/details/743300/identity-column-jumps-by-seed-value

There's another connect item with a better explanation of why it is by design - I recollect it's to do with performance... If I find it, i'll post that...

Hi,

There's a connect item about this somewhere (I'll try and find it). Basically, it's by design. There's a trace flag in the connect item I've linked to (just...

Benki Chendu (2/12/2014)

---

Gila - I would need help in showing my client a document which says 5000 is an agreed value. I can then convince them to tweak my SCOM...

Is it a default instance?

If so, you should have the following SPN's only (against your domain account):

MSSQLSvc/servername.fqdn:1433

MSSQLSvc/servername.fqdn

Delete any others you may have registered against the machine name and the domain...

Is the service account Local System then?

Try using this tool to diagnose kerberos problems

http://www.microsoft.com/en-us/download/details.aspx?id=39046&WT.mc_id=soc-n-

-loc-[Services]-[farukc]

If that doesn't work, can you post your SPN's here: setspn -L domain\serviceaccount

Hi,

There should be a message in the SQL Server error log, e.g. SETTING DATABASE OPTION RECOVERY TO SIMPLE FOR DATABASE XXXXX

Also, i just changed the recovery model on one of...

I believe that if you give the domain group Browser access to FolderD, but don't permission A, B, C, then as long as the root folder doesn't have inheritable permissions...

sorry - what I wrote before was rubbish. I assumed MSA's worked the same way as regular accounts when it came to SPN's.

See if this blog post helps you:...

those states are as expected. It looks as though you've done it okay

colin.hunter (12/16/2013)

---

Hi,

First post here, so thanks in advance.

Trying to set up SPNs for managed service account that are used to access various different DBs on SQL 2012 server. As...