T-SQL script to Backup database SQL Server with TimeStamp
The T-SQL script takes a full backup of all databases(System databases and user databases) in the format of DataaseName-YYYY-MM-DD-HH-MM-...
2022-01-18
53 reads
rajendragupta16
How to Change Always On availability group mode
This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by usin
2022-01-17
50 reads
The SQL NULLIF function
NULLIF is a SQL function that is used to compare two columns. Use NULLIF to compare two columns and return NULL if they are equal to each ot
2022-01-17
40 reads
Troubleshoot SQL Server Backup Error Msg 3132, Level 16
This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database.
2022-01-17
48 reads
Troubleshoot SQL Server Backup Error Msg 3231, Level 16, State 1
When you are experiencing SQL Server Error Msg 3231, Level 16, State 1 while backing up SQL Database, it is important to troubleshoot the er
2022-01-17
489 reads
Troubleshoot SQL Server Error for backups–: Msg 3136, Level 16
Is it possible to use COPY_ONLY backup for restoring differential backups? No, if you try to do so, SQL Server raises error Msg 3136, Level
2022-01-17
71 reads
How to install PowerShell SQLServer module in a specific directory
Troubleshoot error - Install-Module: Administrator rights are required to install modules in 'C:Program FilesWindowsPowerShellModules.'
2022-01-13
73 reads
Troubleshoot PowerShell-No match was found for the specified search criteria,module FailoverClusters
Troubleshoot PowerShell-No match was found for the specified search criteria, module FailoverClusters
2022-01-13
64 reads
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
2022-01-12
51 reads
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
2022-01-12
145 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers