|
I am having a problem with one database on my SQL Server 2005 production server.
A number of databases are already set up for mirroring, however when I right click and go to properties in SSMS, on one particular database there is no "Mirroring" property...
Started by MrEdmundo on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The mirror database has to be created from a full backup of the principal of transaction log backup of the principal database so that the log sequence numbers of the mirror and the principal database....
Check theese items:
2.
|
|
I am having a problem with one database on my SQL Server 2005 production server.
A number of databases are already set up for mirroring, however when I right click and go to properties in SSMS, on one particular database there is no "Mirroring" property...
Started by MrEdmundo on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
I ultimately....
So somehow are database got the ID 3 and now I better getI have been caught out by SSMS respecting database permissions and not showing options for some with mirroring.
Or Mirroring properties are not displayed.
|
|
What is the difference between Replication and Mirroring in SQL server 2005?
Started by Server_Mule on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You can have only one mirror as is being....
You cannot optionally leave out parts of the database.
Mirroring works by shipping the database lg in two places.
And the 'mirror' is always offline (it cannot be modified).
|
Ask your Facebook Friends
|
We're using SQL Server database mirroring and we're trying to create a db maintenance plan to backup the database. The problem is that when the server is not the primary database the plan fails. I was wondering what the best-practice is in this situation...
Started by Darren on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
And dependencies on the mirror server with the jobs disabled
Then use a WMI alert on the DATABASE_MIRRORING with logic to only backup a database that is not in a restoring state like this
There should be a way @primary=1 ....
|
|
Hi folks,
When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database mirroring fails over. I'm curious as to what...
Started by Paul Randal on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Partner time-out is 30 seconds for all db'....
Mirror fail overs are fast, I'd say about 10 seconds at the most.
Each site has a the same number of web servers that use a mirror aware client Database mirroring fail over occur.
|
|
Does Oracle have any built-in features to support a master-slave mirroring mechanism ?
I am looking to mirror/replicate the production server on to a read-only database. The read-only database would be used for reporting and such purposes.
We are using...
Started by Sathya on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
Here is a pretty good description of the manual steps necessary .
However, you will need to license your standby database/server as well.
I don't believe you need DG to use a logical standby database.
|
|
Hi there,
I have two database servers running SQL Server 2005 Enterprise that i want to make one of them as mirror database server.
What i need is, create exact copy a database from primary server on mirror server, so when the primary server was down,...
Started by Dels on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The 'backup' database will be usable after you do two things;
Disable mirroring on it Restore from the backup database....
You would have full access of the mirror if the primary were manually.
database copy for reporting uses.
|
|
Hi folks,
This isn't a how-should-I-do-this question, just to set the stage. It's a what has your experience been? Please read through the whole question before quickly replying.
I spent the day yesterday teaching the current round of SharePoint MCM (...
Started by Paul Randal on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
A colleague of mine has.
With clients implementing clustering but never mirroring in production.
|
|
Guys I'm rolling out a SQL database server that will be used to back Sharepoint 2007. Right now I need some advice on my disk layout. I have two Dell servers that are configured a little differently in terms of storage. The principle server will be using...
Answer Snippets (Read the full thread at serverfault):
I'm not sure how much IO I expect.
The average content database will be no larger than 20 gigs.
|
|
I want to measure the time needed for SQL Server to switch server roles. Is there a way to know how long does it take the mirror to become the principal and ready for new updates?
Thank you very much!
Started by Vimvq1987 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Monitor using the profiler infrastructure for the Database Mirroring State like this:
2010-02-01....
Hope this helps.
:55.220,spid12s,Database mirroring is active with database 'adventureworks' as the principal copy is a SMOC.
|
