Configure SQL Server Database Mirroring
1) Take Full backup of database at Principle Server
BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’
2) Take Log Backup at Principle Server
BACKUP...
2014-10-17 (first published: 2014-10-13)
15,949 reads
MSSQLFUN
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time backup end. Answer : Full backup capture database...
2014-10-06
8 reads
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time...
2014-10-06
756 reads
SQL Server 2008 Service Pack 4 Is Now Available !
Finally after a long waiting period, Microsoft release SQL Server 2008 Service Pack 4, Same is now available for download at the Microsoft Support site. SQL Server 2008 Service...
2014-10-02
7 reads
SQL Server 2008 Service Pack 4 Is Now Available !
Finally after a long waiting period, Microsoft release SQL Server 2008 Service Pack 4, Same is now available for download...
2014-10-02
724 reads
SQL Server 2008 R2 Service Pack 3 Is Now Available !
Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for download at the Microsoft Support site. SQL Server 2008...
2014-09-29
12 reads
SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I perform to resolve the...
2014-09-29
192 reads
SQL Server 2008 R2 Service Pack 3 Is Now Available !
Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for...
2014-09-29
1,248 reads
SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server...
2014-09-29
23,779 reads
SQL Server Cluster LooksAlive and IsAlive Check
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP. Microsoft...
2014-09-22
9 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers