Error

Duplicate post

All replies to this thread http://www.sqlservercentral.com/Forums/Topic1734147-3411-1.aspx

You can run xp_logininfo against all the groups in on the server and note which groups the user is in

exec xp_logininfo 'DOMAIN\Group','members'

Service accounts should be changed via config manager not services.msc.

Open up config manager switch the account back to the original account, then switch it back to domain account. This...

0x5 is an access denied error.

When you changed the service account did you use services.msc or SQL Server Config Manager?

Also if backing up to a network share, does the accounts...

Use the IFCode IMG and past a URL to an image inbetween the [ I M G ] and [ / I M G ] tags (remove spaces from the...

Think that still reads the default trace

Announcement

Unless you have some form of monitoring to log when it happened, you could have a go at looking in the default trace, but note the default trace only keeps...

Taken from the following url https://gallery.technet.microsoft.com/scriptcenter/List-datasets-with-command-ddffefde

And changed to fit your sample script and namespaces.

;WITH

XMLNAMESPACES

(DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition'

...

77% of your total wait time is on WRITELOG, yes that maybe high for your workload, it might not be, depends on the workload.

I have a heavy write syslog server...

It might be high, it might not be high, you cant just go off a one time select of the value, you need to monitor over time.

Adding another file wont...

Depends on your disks, might be normal, might not be.

How are you determining that...

Maybe this will help

http://blog.sqlauthority.com/2011/02/17/sql-server-writelog-wait-type-day-17-of-28/

Sorry I can't understand the question, what is it your after?