Skip to content

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, .Net etc…

  • Home
  • SQL Server
    • Administration
    • Diagnostics
    • Performance
    • Security
    • T-SQL
    • Tools
  • PowerShell
    • Remoting
    • Tools
  • Linux
  • .Net Development
    • Visual Studio
    • C#
    • MVC
    • ASP.NET
  • Servers
    • IIS
    • SharePoint
    • Hyper-V
    • MSMQ
  • Windows

Category: Administration

Removing TempDB data files from SQL Server

Posted on 01/05/201701/05/2017 by Lincoln Bovee'

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

Read More

Protected: Installing SQL Server on Linux

Posted on 11/28/201608/27/2018 by Lincoln Bovee'

There is no excerpt because this is a protected post.

Read More

Using the KILL command

Posted on 11/22/2016 by Lincoln Bovee'

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

1
KILL [SPID] WITH STATUSONLY

Views – 1799

Read More

About Replication

Posted on 09/28/201610/06/2016 by Lincoln Bovee'

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

Read More

Tearing down SQL Server Replication

Posted on 06/17/201606/20/2016 by Lincoln Bovee'

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

Read More

Manually removing log-shipping

Posted on 04/25/201601/31/2017 by Lincoln Bovee'

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…

Read More

Resolving the “Backup detected log corruption in database”

Posted on 04/14/201612/01/2017 by Lincoln Bovee'

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

Read More

MSDB is in “Recovery Pending” state

Posted on 04/14/2016 by Lincoln Bovee'

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

Read More

Moving the TempDB database to a new drive

Posted on 03/22/201609/16/2017 by Lincoln Bovee'

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

Read More

Moving system databases to a new drive

Posted on 03/22/201603/10/2017 by Lincoln Bovee'

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

Read More

Posts navigation

Previous 1 2 3 4 … 7 Next

Recent Posts

  • About TempDB and the Version Store 07/16/2019
  • Using PowerShell to Failover Availability Groups and WFC Cluster Nodes 05/21/2019
  • About Availability Groups Database Seeding 04/19/2019
  • About Collations in SQL Server 04/10/2019
  • PostgreSQL vs. SQL Server Notes 02/13/2019
  • Restoring a database using STOPATMARK 01/11/2019
  • Availability Groups: Things to remember 12/07/2018
  • Properly Taking a Cluster Offline for Disk Maintenance 08/14/2018
  • Building an AlwaysOn Availability Group SQL Cluster 03/07/2018
  • Some database design guidelines and best practices 01/29/2018

RSS Paul Randal’s Blog

  • The Mentoring Class of 2023 12/20/2022 Paul Randal
  • Mentoring 2023 – want some help from me? 12/01/2022 Paul Randal
  • The Curious Case of… community 11/27/2022 Paul Randal
  • The Curious Case of… disconnected AG secondary replica and transaction log out of space issue 10/18/2022 Paul Randal
  • The Curious Case of… eager writing and minimally-logged operations 04/12/2022 Paul Randal

RSS Brent Ozar’s Blog

  • Office Hours: Questions That Didn’t Make the Cut 03/23/2023 Brent Ozar
  • [Video] Office Hours in Cartagena, Colombia 03/22/2023 Brent Ozar
  • It’s Monday. Do You Know Where Your PowerShell Training Is? 03/20/2023 Brent Ozar
  • Slow Startup, Failover, and Restore Times with In-Memory OLTP 03/16/2023 Brent Ozar

RSS Richard Siddaway’s PowerShell Blog

RSS SQLBlog.com Posts

RSS MSN PowerShell Blog

  • PSReadLine 2.3.0-beta0 Release 03/13/2023 Steven Bucher
  • PowerShell Extension for Visual Studio Code February 2023 Update 02/23/2023 Sydney Smith
  • PowerShell/OpenSSH Team Investments for 2023 01/23/2023 Steve Lee
  • PowerShell Extension for Visual Studio Code January 2023 Update 01/21/2023 Sydney Smith
  • PowerShellGet 3.0 Preview 18 01/12/2023 Sydney Smith
Powered by Newp WordPress Theme. © 2023 LincolnBlog.net. All Rights Reserved.