Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts tagged SQL Server

I recently had to rename my laptop on which I have two SQL server instances.  I have a default instance and a named instance.  I actually have had the laptop renamed for awhile without any issues, but it’s not production and I don’t use it every day.  I first encountered the error while creating a […]

This week I had an application team report the error “SQL Connection Lost”.  Fortunately they also reported the exact times of occurrence, which made it much easier to hunt down.  I did some digging through the SQL logs and DMVs, but did not find anything that indicated SQL was dropping the connection.  I also did […]

I recently had the need to move the MSDTC for a cluster to a new SAN drive.  It’s a quite simple thing to do, but you can’t redirect the MSDTC resource to a new drive.  Let’s just walk through the basic steps. The first thing you need to do is get the new drive added to the cluster and […]

Do you get error 435 in the Application event log and your SQLAgent fails to start?  The reason you’re getting this error is that the SQLAgent error log and working directory file locations are not available. I recently ran into this after moving the user and system databases to a different SAN drive.  Even though you tell SQL […]

Note that TempDB is recreated every time SQL starts.  Why is this important?  It means we don’t have to move the physical file on the file system. First we need to know the name and file location of the TempDB database files.  When you change the location, make sure to keep the same name.  Technically we don’t […]

First we need to know the name and file location of the MSDB database files.  When you change the location, make sure to keep the same name.  Technically we don’t need the current physical path, but it’s just a good idea to have it documented in case things go badly. SELECT name, physical_name FROM sys.master_files WHERE database_id […]

First we need to know the name and file location of the Model database files.  When you change the location, make sure to keep the same name.  Technically we don’t need the current physical path, but it’s just a good idea to have it documented in case things go badly. SELECT name, physical_name FROM sys.master_files WHERE database_id […]

The catch to moving the Master database is that you must also move the Resource database.  Microsoft states that the Resource database must reside in the same location as the Master database.  You can see their instructions HERE on how to move the Master database. However, on my cluster I did not find the Resource […]

How to create a DSN on Windows 64bit for your 32bit application

How to enforce a stored procedure naming convention with policy based management.