Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 708

For questions about database mirroring - a technology used to create and maintain an exact copy of a database, synchronously or asynchronously.

3
votes
Error 3456 is an LSN mismatch error and indicates a corrupted database. Recovery will not succeed in this database. As removing the mirroring on the database involves running recovery and recovery …
answered Jan 22 '13 by Remus Rusanu
2
votes
This is not a question of replication, nor mirroring. Is about updating the app. You should have a deployment strategy for your app, including upgrade. Updating the 'demo' would simply mean running …
answered Aug 13 '14 by Remus Rusanu
13
votes
Step 1: Create a service to receive the notifications and a queue for it: use msdb; go create queue dbm_notifications_queue; create service dbm_notification_service on queue dbm_notifications_qu …
answered Jan 12 '12 by Remus Rusanu
2
votes
Your .LDF log is growing, as it cannot be truncated because the mirror is unavailable. Eventually you'll run out of space unless you either break the mirroring or bring the mirror back online. …
answered Mar 9 '12 by Remus Rusanu
2
votes
Can you check you sys.dm_os_schedulers ? Specifically, does work_queue_count deviates from 0 for any significant time? This would indicate worker starvation and would explain many of your symptoms.
answered Aug 14 '12 by Remus Rusanu
3
votes
See the Books Online documentation for sys.database_mirroring_endpoints For server object permissions you look at the usual place, sys.server_permissions. As with every case when Windows security is …
answered Nov 29 '12 by Remus Rusanu
2
votes
Neither mirroring nor replicaiton are appropiate here. Mirroring creates identical physical copies of the database. Replication is good at replicating data, but falls short exactly at replicating …
answered Dec 14 '11 by Remus Rusanu
2
votes
Certificate based authentication of Database Mirroring is explained in How Does Certificate based Authentication Work. After your server rebuild you should had open the master database database … . You do not have to drop the endpoint, nor the mirroring related users and certificates. You can simply create a new certificate, then associate the new certificate with the existing endpoint using …
answered Jan 12 '12 by Remus Rusanu
2
votes
Database Mirroring Monitor (Status Page): Time to send log (estimated) Approximate amount of time the principal server instance requires to send the log that is currently in the send queue to …
answered May 30 '13 by Remus Rusanu
2
votes
Use Replication. It does exactly what you need.
answered Dec 11 '15 by Remus Rusanu
1
vote
partner on mirror, then primary. When the mirroring session is established the primary must have the current LSN of the mirror-to-be in the active log. This is necessary so that the primary can … should end up with a proper mirroring candidate database. But if you only restore the full backup then the mirror will be at LSN1 and the primary will reject it. …
answered Mar 11 '14 by Remus Rusanu
5
votes
...) and go straight to the source: create an event notification for the Database Mirroring State Change Event. Deliver the notifications locally to your [msdb] database. Then you can react in your … activation procedure directly to the state change notification. Yo do not need any TCP or other communication, each mirroring partner can do this monitoring independently and each partner reacts to the local …
answered Jan 3 '12 by Remus Rusanu
3
votes
A SQL Server instance can host multiple mirroring partnerships. Mirroring is between databases and databases are hosted on SQL Server instances, so choosing a name like 'DBx' for servers is a rather … database DB2 mirrored by SRV3 (primary) and SRV2 (secondary) But the question is What do you use mirroring for? Primarily it is a High Availability feature. The question is: will the SRV2 instance be …
answered Mar 18 '13 by Remus Rusanu
2
votes
SQL Server 2016 introduces Standard Edition support for AlwaysOn Availability Groups. It supports 2 nodes only, but as a replacement for mirroring that should be no problem. …
answered Jul 13 '15 by Remus Rusanu
1
vote
I would recommend you read Replication and Database Mirroring: Supported starting in SQL Server 2008 for transactional replication with manual failover and configuration. The replication agents … to restore the replication stream. For more information, see SQL Server Replication: Providing High Availability Using Database Mirroring. The linked document in turn states: Prior to the …
answered Jun 26 '12 by Remus Rusanu

15 30 50 per page