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,945 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...
2014-10-17 (first published: 2014-10-13)
15,945 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
7 reads
Question : When you take full backup, do it capture data till the time backup start time or till the time...
2014-10-06
754 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
7 reads
Finally after a long waiting period, Microsoft release SQL Server 2008 Service Pack 4, Same is now available for download...
2014-10-02
721 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
7 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
140 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,246 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,772 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
8 reads
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Comments posted to this topic are about the item Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers