The issue was that before, when you  needed to create, or extend a data file in SQL Server, it would start a process called zeroing that will start writing zeroes...

yes, standard edition supports it when its synchronous-commit mode which is the only way you can use the automatic failover. in both versions, standard and enterprise.

The only thing is that...

What if these users are in another AD groups that have access to the databases?

You would have to dig deeper, you might have different groups and these users may be...

I think you can't do anything besides getting more storage or fixing the application.

We can wait to see what the gurus have to say, they might have some different approach.

Remember...

Going into tempdb and dropping tables is wrong, maybe an application is using the tables to make some work and by deleting it you are affecting production, or affecting your...

So you are in an AG, in 2016 they added the DTC_Support per DB so you didn't have to create it at the WSFC level.

This information can come in handy...

That sounds REALLY interesting, i have never been the type of person and i didn't knew you could make these kind of changes inside the engine if not using MSFT's...

It really depends on your security context, if you want to go the easy way with security just create the user that's gonna be connecting to the remote server in...

They should add something like "Create", "modify" and "Drop" linked servers, i think that should be the way to go.

In our case, we had to give it to the IT...

If that's true, I wish the OP would state...

• This reply was modified 4 years, 8 months ago by  Alejandro Santana.

Hey,

You can't just put the server name in the naming convention, it has to be a linked server name.

You have to create a linked server as your listener as the...

If im not mistaken, you'll have to wait, you can't stop rollbacks, if you restart the instance it'll start rolling back again or pick up where it left.

Its also worth noting that, because you ran DBCC CHECKDB on a secondary to offload and it didn't presented corruption, it doesn't mean you don't have corruption on the primary...

We are using the same tool that StackExchange, StackOverflow uses, it supports a really wide range of applications to monitor but we are using it for SQL Server, it's open...

Hey,

According to Paul Randal:

"I strongly advise not using BACKUP DATABASE ... WITH CHECKSUM as an alternative to DBCC CHECKDB - it will not detect errors introduced by memory problems, SQL...