Hi,
It depends on your setup. If you use mirroring with witness-server, the wittness-server knows the state of the mirror nodes. If you don't use a wittness-server, the primary node...

Hi,
you should take a look on the page from ola hallengren

https://ola.hallengren.com/sql-server-backup.html

Very good scripts for backups, the scripts know, if the node is the primary...

Hi,
IO Frozen locks like backup software with snapshots.
What about scheduling, agent jobs, external tasks?
Kind regards,
Andreas

Hi,
this would be easier with the extended events.
If you use the SSMS 2017.x, there are 2 extended event sessions under XEvent Profiler.
With this 2 sessions you are...

Hi,
you are able to attach the mdf file without the ldf file. But you may lost a lot of data.
If you are not able to lost your data,...

Hi,
it depends. Do you know the workload of your database now?
How much orders will be more in december.
You should know your RAM consumption, your IO and your...

Hi,
difficult, but I  try to explain:

AlwaysOn Failover cluster instances
If a failover occurs, the  instance did a failover
All  objects are on the new instance, jobs, logins,...

Hi,
try to put the query in a sql job. Export the result to csv via job step and the user could import the csv file to excel.
What do...

Hi,
what kind of maintenance plan are you creating?
There are a lot of wunderfull scripts from ola hallengren, they can do a lot more then the maintenance plans.
Kind...

Hi,
are you able to change the destination of the audit from the ring buffer to a local file?
And, are there more informations in the ERRORLOG?
Kind regards,
Andreas

Hi,
do you mean something like that:


SELECT servicename,
   last_startup_time,
   service_account
FROM  sys.dm_server_services


Best regards,
Andreas

Hi,
I am sorry, but there is no best way.
It depends, how many servers, and what is your goal of monitoring. Would you get any kind of alert, if...

Hi,
try this kind of query:

https://stackoverflow.com/questions/5945360/sql-server-2008-how-to-query-all-databases-sizes/26674621#26674621

There is a column with unused space. And by the way, much more helpful than the reports in the SSMS.

Hi,
here are some usefull tips:
https://www.sqlservercentral.com/Forums/1614520/Intellisense-on-some-databases-not-others?PageIndex=2
Have you got an unused linked server?
Or do you use different version of SSMS?
Kind regards,
Andreas

Hm,
I am  confused. Do you mean this function in the SSMS:
IntelliSence enabled ?
I didn't  hear something like "embedded intelligence" with a SQL Server.
Have you got a...