@Emporer100: The...

The SQL Server service accounts need read permissions on the private key of the certificate, on both nodes.

What?? 1. A File Server resource group has nothing to do on an AlwaysOn AG server. 2. The underlying wsfc is controlled by the sql server. So a failover has...

In newer Versions of SQL Server and SSMS you don't need to remove the missing LDF. Please correct your article. It seems it is for old SQL Server 2005 or...

Hi Deubel, could you elaborate further on what sort of script i need to run?

So does this means I do not need to backups any of my system database...

Thanks for all the reply.

Just 1 more thing to clarify, if I were to upgrade my database from SQL 2012 to SQL 2019 & I want to retain all...

duplicate post

• This reply was modified 11 months, 3 weeks ago by deubel_m.

The most important question is: How much downtime do you get?

What is there to be confused about?

You have two servers, and two accounts. One is a sysadmin on one server, the other is not.

Sysadmin is the highest level of...

I hope the text below helps you understand.

SQL Server provides server-level roles to help you manage the permissions on a server. These roles are security principals that group other...

Due to security i could not export data from the particular DB. I imported the very same flat files into my personal DB , with no issue. YOU could...

Due to security i could not export data from the particular DB. I imported the very same flat files into my personal DB , with no issue. YOU could...

I would like to understand how to create auto job to take the full backup, transaction backup + truncating the log files(without making the database to simple recovery mode...

Why do you make backups with Veeam and with SQL Server? If Veeam B&R is configured correctly it truncats the logs for you. But I'd prefer SQL Server backups. With...

Maybe a screenshot would make things clearer.