How to move the MSDB database
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
956 reads
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
956 reads
First we need to know the name and file location of the Model database files. When you change the location, make...
2011-07-12
6,572 reads
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the...
2011-07-11
1,368 reads
You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until...
2011-07-06
1,316 reads
This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is...
2011-06-14
699 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers