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,951 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
10 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
758 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
14 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
730 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
25 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
221 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,255 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,782 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
16 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers