I think you could get the information through Extended Event, try Brent Ozar's "What queries are failing" Extended event.

https://www.brentozar.com/archive/2013/08/what-queries-are-failing-in-my-sql-server/

If you need more information i think you could modify...

The test we made today was the next one.

Since the repair_allow_data_loss of one of the tables is taking way too long.

We eliminated all the indexes (Clustered, non clustered), keys, constraints...

• This reply was modified 5 years, 2 months ago by  Alejandro Santana.

In our case to access production servers, we must send an email to IT Sec telling them the reason why and which tool it is and explain the reason.

Since we...

You are welcome! 🙂

Glad to be of any help!

No, you don't need to restart the services, most of kerberos commands if not all can be done on the fly, services won't be interrupted.

When you change from dynamic port...

Yes, clean everything before adding another SPN, since it may confuse the services.

Hey!,

Just to clarify ... we have 2 instances on this server and only the second appears in the results above

Can I just run the command to add the default...

Hello

Have you tried executing your procedures manually?

Greetings

Is it a differential or a full backup?

The time it took was the doubled or more?

Everytime you make a backup SQL server writes in the log the amount of pages...

You are welcome.

Thanks for the feedback and letting us know everything went well.

Greetings.

No, there's no downside besides the one you said, using up storage.

They should be gone actually, these won't be helpful unless you don't have your back ups up to date...

I think the first time you have to manually set it, after you set it, verify.

SELECT net_transport, auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid

If it's working try...

Hello,

You should configure Kerberos in your SQL Instance.

Register a Service Principal Name for Kerberos Connections

How to troubleshoot the "Cannot generate SSPI context" error message

Microsoft offers a tool...

It's actually the same process as normal databases, just make sure your Report Server service can still reach the SAME instance it was configured with.

Report Server service doesn't handle the...

This usually happens if your backup have been encrypted, it happened to me when it was encrypted by certificate or maybe different sql server versions, if the backup is from...