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
13 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
195 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
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers