SQL Server Docker and Container Cheat Sheet

I've started working with Docker platform and managing SQL Server Containers. This list are some of the commands I execute most often when using Docker and Containers. --Pull down a container from the Docker registry docker pull --(generic approach)Pull down a sql server container to a valid docker installation on RHEL and run (generic approach) docker pull microsoft/mssql-server-linux docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=LinuxSQLServer123' -p 1433:1433 -d microsoft/mssql-server-linux --(customised approach)Pull down a sql server container to a valid docker installation on RHEL and run Step 1 - Mapping volume names with customised locations **comment - data volume** docker volume... Read more →

The transaction log for database is full due to LOG_BACKUP

Question: I'm getting the The transaction log for database is full due to LOG BACKUP Error 9002 Severity 17 State 2 error message . When I look at the Message associated with the error message the details are "One or more recovery units belonging to database 'database_name' failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log for more detailed information on this failure" I can see clearly the disk space available on the drive is... Read more →

How to get SQL port number using xp_readererrorlog

If using a fixed port or dynamic port , get the xp_readererrorlog via scanning Read more →

Unable to start services after patching - msdb110_upgrade.sql' encountered error 574, state 0, severity 16.

Question : During a recent round of patching , I've been frequently seeing msdb110_upgrade.sql' encountered error 574, state 0, severity 16 in the Event Viewer when the service for the SQL Server Instance is attempting to start. How can I resolve this issue? The service will not currently start. I've checked in the SQL Server Error log file via a text editor and can see A problem was encountered granting access to MSDB database for login '(null)'. Make sure this login is provisioned with SQLServer and rerun sqlagent_msdb_upgrade.sql The lines in the SQL Error Log are: 2018-09-09 13:41:56.88 spid5s Granting... Read more →

INSERT BULK in Profiler trace

In a Profiler trace you can see INSERT BULK statements , which are a mechanism for interface between SQL Server and a client bulk copy API.For example : .Net SqlBulkCopy & ODBC Bulk Copy methods. The Profiler trace whill display the INSERT BULK statement but the FROM part , meaning you cannot view the values. The INSERT BULK statement specifies the target tables \ columns including other meta data information - NULL management , triggers etc The tricky bit from a troubleshooting per, spective is you cannot view the values in the INSERT BULK statement. The values are transfered in... Read more →