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 LOG USERDB1 TO DISK =...
2014-10-13
6 reads
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 LOG USERDB1 TO DISK =...
2014-10-13
6 reads
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
9 reads
Question : When you take full backup, do it capture data till the time backup start time or till the time...
2014-10-06
757 reads
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
8 reads
Finally after a long waiting period, Microsoft release SQL Server 2008 Service Pack 4, Same is now available for download...
2014-10-02
725 reads
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
17 reads
Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for...
2014-09-29
1,250 reads
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
202 reads
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server...
2014-09-29
23,781 reads
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
11 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers