Just a quick heads up: I have just realized. On my Firefox browser I can not see the steps from 5 to 7 and on Edge and Chrome steps 5...

Thanks a lot! Much appreciated.

Hi,

Thanks for you post. #

I want to remind that in the books online https://msdn.microsoft.com/en-us/library/ms187103.aspx, changing the monitor server is not supported. Saying that, I think that it can be done...

Hi,

Current sessions on the failing node will be lost. You have to add some logic in your application to reconnect.

Hi,

SQL Server AG or FCI executes a stored procedure sp_server_diagnostics that will return four event level messages (Clean, Warning, Error, Unknowns) from five component families:

system

resource

query_processing

io_subsystem

events

sp_server_diagnostics (Transact-SQL)

https://msdn.microsoft.com/en-us/library/ff878233.aspx

Then, depending on the fail...

Hi,

Maybe you have read permissions on the share folder but not write access. Use the same method above but creating a new file. Like echo hello > \\share\file.txt

Regards

Good choice. Do not forget to check IBM red books for best SQL Server storage configuration. They usually give good advise, specially if you will use hybrid or multi-layer configuration.

Hi,

Does it happen with SQLCMD client?

Sorry but it looks confusing. Do you mean joining an additional SQL Server instance as secondary replica or add a Listener resource (new IP Address, and new network name) to...

Hi,

Just an additional tip: Ensure that text column values do not have any kind of escape character at the beginning or the end during conversion. For example while importing a...

Hi,

Gila is right. That would fix your issue. Is not critical but do not forget assigning the same server roles to the underlying user login object too just in case...

Hi,

Also check the first lines in the error log if there are messages related to SPN registration like this one.

--The SQL Server Network Interface library could not register the...

Hi,

Well, there is the "CPU idle condition" configuration in the SQL Server Agent service configuration but it is almost useless. An interesting option that could suits you is enabling...

Hi,

Have you tried to attach a SQL Server Profiler so you can see what is doing while you open the restore window? It maybe give you some hint.

Sorry for not...

Hi,

I have always felt that 4Gb RAM is a really low value for most common SQL Server environments. Specially in x64 architecture. I should recommend 8Gb. minimum. Maybe you can...