Properly Taking a Cluster Offline for Disk Maintenance
I recently needed to replace the older, slower attached disks on our clustered SQL instance offline so as to copy each drive to…
Category: Administration
Random SQL tips and best practices
Kevin Kline posted on wait states here with some valuable insight: TROUBLESHOOTING SQL SERVER WAIT STATS A number of these are from Adam…
What is a .TUF file in the DATA folder?
The TUF files you see in the ..\DATA folder is a “transaction undo file” which contains modifications to the database that were not…
Bulk-copy SQL Server Agent jobs to new server
The easiest way to bulk-copy all SQL Agent jobs to a new server is to follow these steps 1. Load SSMS and connect…
Configuring SQL Database Mail
Here is a sample script for configuring database mail in the event you want to automate your SQL installs.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
EXEC sys.sp_configure 'Advanced options', 1; RECONFIGURE EXEC sys.sp_configure; USE msdb GO --Step1: Varifying the new profile SELECT * FROM sysmail_profile --Step2: Verifying accounts SELECT * FROM sysmail_account --Step3: To check the accounts of a profile SELECT * FROM sysmail_profileaccount WHERE profile_id = 3 --Step4: To display mail server details SELECT * FROM sysmail_server select * FROM sysmail_allitems |
…
Removing TempDB data files from SQL Server
I had a situation where a SQL Server 2016 install did not install correctly. The install completed but when I tried to move…
Protected: Installing SQL Server on Linux
There is no excerpt because this is a protected post.
Using the KILL command
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 – 970
About Replication
Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL…
Tearing down SQL Server Replication
I recently was engaged in updating the Compatibility Mode of our production databases to 110 (2012) in preparation for upgrading them all to…