Add Database File on Database invloved in DB Mirroring
Add Database File on Database invloved in DB Mirroring.
2014-10-29
525 reads
MSSQLFUN
Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !
The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 4 contains all the hotfixes released since the...
2014-10-27
14 reads
Remove Witness from SQL Server Database Mirroring
1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2) To remove the witness, delete its server...
2014-10-27
21 reads
Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !
The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...
2014-10-27
799 reads
Remove Witness from SQL Server Database Mirroring
1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2)...
2014-11-07 (first published: 2014-10-27)
7,418 reads
Add Database File on Database invloved in DB Mirroring
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not...
2014-10-20
18 reads
Add Database File on Database invloved in DB Mirroring
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file...
2014-10-30 (first published: 2014-10-20)
7,135 reads
Database Mirroring States (SQL Server)
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :- Mirroring state Description SYNCHRONIZING The contents of the mirror database are lagging behind the contents of...
2014-10-14
6 reads
Database Mirroring States (SQL Server)
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :-
Mirroring stateDescriptionSYNCHRONIZINGThe contents of the mirror database are...
2014-10-14
1,994 reads
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
13 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers