Add Database File on Database invloved in DB Mirroring
Add Database File on Database invloved in DB Mirroring.
2014-10-29
522 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
4 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
7 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
795 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,403 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
5 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,120 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
5 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,989 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
5 reads
Blogs
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Streamlining Azure VM Moves Into Availability Zones
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
Monday Monitor Tips: Native Replication Monitoring
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
Forums
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The Challenge of AI
Comments posted to this topic are about the item The Challenge of AI, which...
Deprecated Feature Tracking
Comments posted to this topic are about the item Deprecated Feature Tracking
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers