MSSQL

[MSSQL] The database cannot be recovered because the log was not restored

August 3, 20200

How to Change the Default SQL Server Backup Location

July 26, 20201

How to Find SQL Server Instance Name

July 26, 20202

(MSSQL) Database is already open and can only have one user at a time

July 13, 20200

How to Obtain the Date/Time when Service Package was Applied to SQL Server

June 29, 20200

MSSQL Frequent Used Terms & Acronyms

June 29, 20200

[SQL] Could not find the Database Engine startup handle (Component error code: 0x851A0019)

May 28, 20200

[SQL] Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) & encryption changes on database must be serialized

May 28, 20200

[SQL] Could not drop login as the user is currently logged in.

May 28, 20201

How to Perform Detach & Attach MS SQL DB

May 26, 20200

SQLServerAgent cannot start SQLServer Error: 21, Encryption not supported on the client

May 17, 20201

How to Rename SQL Server Logical DB Filename

April 26, 20200

Error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

April 25, 20200

How to Split / Create Multiple Backup Files of MSSQL Database

April 22, 20200

How to Obtain Microsoft SQL Server Cumulative Update / Service Pack

April 8, 20200