Command: xp_readerrorlog parameter 1, parameter 2, parameter 3, parameter 4 Parameter 1: To specify the errorlog number. Starts from 0. 0 = current, 1 =…
Question After connecting to SQL Server using SQL Server Management Studio, I am not able to see the green play arrow on the SQL Server…
At first I thought starting SQL Server in Single user mode is easy in Windows 2008 fail-over cluster. But I was wrong, If I just…
Why do we need this? By default, you might be having the stock media package which will give you a SQL server without the latest…
Log-in to the active node. Trigger a full backup for all System and User Databases. Script out all log-ins. If there are any user databases,…