during the period where the endpoint was one stop can I have lost data?

You will not lose data when the Primary Replica cannot communicate with a Secondary Replica. The...

Run the next query and see if its attached to any database.

Select * from sys.master_files

with the query above you could see if the file is attached to...

Hello,

1. Windows Updates are automatic unless they require the server reboot, it'll ask you for a time to restart the server.
2. Yes they might be part of windows updates, no...

• This reply was modified 5 years, 6 months ago by  Alejandro Santana. Reason: Added the last paragraph

Nice, i didn't knew it.

I was testing with adventure works, it lets you choose multiple directories for your database, depending on how many data files there are after the validations...

If i recall correctly DMA is not used to migrate the database per se, its used to collect the prerequisites you need to migrate from one version to another, it...

Hey,

I only enable it to check SQL Server logs across different servers and checking the msdb backup tables, i know you could use the Registered Server option for that or...

Hey,

In our case the main reason we have TempDB in another drive is because:

• If some big bad query starts running if it takes hours it would use the whole...

Thanks for replying!

The 3rd party certs you've used for encryption have been at the backup level or using TDE?

I'm reading right now PowerShell command New-SelfSignedCertificate to see if i can...

• This reply was modified 5 years, 7 months ago by  Alejandro Santana. Reason: Added CREATE CERTIFICATE Remarks URL

When we migrated from 2008 R2 to 2016 we saw some cases of queries that ran smooth in 2008 R2 and in 2016 they would take minutes!

To fix the issue...

• This reply was modified 5 years, 7 months ago by  Alejandro Santana. Reason: Added the third OR option

Hi!

While i don't think there's a script to make that job the next links can provide some help.

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2012-R2-and-2012/dn466519(v=ws.11)

https://docs.microsoft.com/en-us/windows-server/failover-clustering/configure-ad-accounts

Greetings.

When we migrated from SQL Server 2008 R2 to 2016, one of our largest database had 8TB size, but in our case we had a window, we prepared everything and...

I have been getting those messages at the QA and Development instances and its like Sue_H said, check your log size, when its full that's the message it will throw.