Administration – Page 2 – LincolnBlog.net

I had a situation where a SQL Server 2016 install did not install correctly. The install completed but when I tried to move…

There is no excerpt because this is a protected post.

You can view the status of a KILL command used to stop an open transaction by typing the following:

KILL [SPID] WITH STATUSONLY

1	KILL [SPID] WITH STATUSONLY

Views – 1799

Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL…

I recently was engaged in updating the Compatibility Mode of our production databases to 110 (2012) in preparation for upgrading them all to…

I have had a number of situations where log-shipping broke and I needed to rebuild it but could not drop the log-shipping configuration…

I saw this in the SQL logs today. It looks like some corruption happened in the transaction log of a specific database. I…

I had a SQL Server at work today where I found the msdb database in “Recovery Pending” state. After reading a number of…

Often you will need to add or move the tempDB data files, either to match the core count (up to 8 as best…

A common task for any DBA building new SQL servers is to relocate where SQL Server stores user and system databases. This post…

LincolnBlog.net