|
More site info...
Database Mirroring | Forum profile
|
|
Forum profile page for Database Mirroring on http://technet.microsoft.com.
This report page is the aggregated overview from a single forum: Database Mirroring, located on the Message Board at http://technet.microsoft.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Database Mirroring" on the Message Board at http://technet.microsoft.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Database Mirroring:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
11
|
37
|
130
|
|
Post:
|
21
|
59
|
218
|
|
|
Database Mirroring Posting activity graph:
|
Top authors during last week:
user's latest post:
Can 32-bit witness be used with...
Published (2008-11-29 07:52:00)
Adding to what Aaron mentioned, you can even use SQL Server Express edition as a witness server. - Deepak Deepak | Mark the answers if it helps to solve your problem |
user's latest post:
mirror principal orphaned -...
Published (2008-11-27 12:44:00)
Has it stopped being busy? You may also try to issue these commands: ALTER DATABASE dbname SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS ALTER DATABASE dbname SET PARTNER OFF Bodo Michael Danitz - MCITP Database Administrator
user's latest post:
Mirror or TLS - TechNet Forums
Published (2008-11-27 03:07:00)
Thanks Bodo, I've referred the router question to my network engineers. Has anyone had issues with Microsoft Support on mirroring? I noticed on one of the servers the popup, warning against using mirroring in production environments, though to the best of my knowledge it is a common implementation.
user's latest post:
Do Microsoft support DB...
Published (2008-11-29 09:55:00)
AFAIK The only supported virtualization technology for running SQL Server is Hyper-V and it applies only for configurations that have passed the Server Virtualization Support Program. See http://support.microsoft.com/Default.aspx?id=956893 Under Hyper-V all SQL Server technologies are supported except Guest Failover Clustering. http://rusanu.com/blog
user's latest post:
Can 32-bit witness be used with...
Published (2008-11-29 04:15:00)
Yes, Yes, No, and Yes. The Witness and Primary/Mirror servers do not need to be using the same processor architecture. The Witness can, and often should, be less powerful than the Primary and Mirror. Just keep in mind that the Witness needs to have very high uptime > when the Witness is down, you no longer have automatic failover. Transactional information does not flow through to the witness. It basically serves to establish a...
user's latest post:
Where need to store Transaction...
Published (2008-11-29 04:01:00)
Yes, Now its working fine. THanks a lot for your tips. Thanks, Manian.R Expect Good idea to develop a i-world
user's latest post:
Do Microsoft support DB...
Published (2008-11-28 18:52:00)
Can anyone provide the link that shows that MS supports the DB Mirroring on VMWARE environment, if that is a case ? Thanks Prashant Thakwani
user's latest post:
Can 32-bit witness be used with...
Published (2008-11-28 17:51:00)
Can 32-bit witness be used with 64-bit primary and mirror for SQL Server 2005? Can witness be less powerful than primary/mirror? Does transactional information travel via witness or it only "pings" primary and mirror from time to time?
user's latest post:
Where need to store Transaction...
Published (2008-11-27 14:53:00)
Check out the following article: Database Mirroring in SQL Server 2005 It discusses mirroring error 1412 and the solution to it. Let us know if helpful. Kalman Toth, SQL 2008 & Business Intelligence Training: www.SQLUSA.com
|
|
|
|
Latest active threads on Database Mirroring::
Started 5 days, 22 hours ago (2008-11-28 18:52:00)
by Prashant Thakwani
Can anyone provide the link that shows that MS supports the DB Mirroring on VMWARE environment, if that is a case ? Thanks Prashant Thakwani
Started 5 days, 23 hours ago (2008-11-28 17:51:00)
by JoeSchmoe115
Can 32-bit witness be used with 64-bit primary and mirror for SQL Server 2005? Can witness be less powerful than primary/mirror? Does transactional information travel via witness or it only "pings" primary and mirror from time to time?
Started 1 week ago (2008-11-27 11:46:00)
by Manian.R
Hi Experts, When Create Mirror Database Server, Where need to store the Transaction Log backup file? I took FULL Backup of my Primary Database, and I restored at my Mirror Server also. When I try to create a Mirror Database, I am getting the below error Missage: "The remote copy of database "<db_name>" has not been rolled forward to a point in time that is encompassed in ...
Started 1 week ago (2008-11-26 20:44:00)
by JebSmith
Well, I had an interesting day and I hope someone can point me in the correct direction. We have mirroring installed and working with auto failover - synchronous with a witness and we had a network failure. Mind you we were under very heavy i/o load a the time also. When we moved all the ports for these servers to another switch, the mirror thought it was principal, the principal could ...
Started 1 week ago (2008-11-26 22:46:00)
by S Sedgwick
Hi Everyone! No doubt this get's asked quite often .. feedback on some options. A while back we implemented TLS to replicate our core database (then 30GB) across a 1mb DSL link to a secondary server. This has been working quite well. Recently we have continued to have issues with long delays in restore times which just can not restore the logs quick enough. Our database is ...
Started 4 weeks, 1 day ago (2008-11-05 02:09:00)
by pinoyz
How to make a database mirrored? Do i need to code for each database to fill the each database table? Regards noob vb programmer
Started 1 week, 6 days ago (2008-11-21 16:10:00)
by Taylor25
We occassionally see a phenomenon with the database mirroring monitor job where it will run for an excessive length of time, usually over 5 minutes, and consumes many gigs of tempdb log space. In several cases this has caused tempdb's log to fill, and subsequently the db mirroring monitor job will fail. On the next run of the job, it's back down to sub-second run times. The ...
Started 7 months, 1 week ago (2008-04-29 13:57:00)
by rossco_1
Hi, We have a SQL Server 2005 SP2 server setup for mirroring to another 2005 SP2 server in the same domain and every now and again at random times and intervals we receive the following error message in the logs Database mirroring connection error 4 '64(error not found)' The mirroring for each database automatically reconnects about 1 minute later so ...
Started 1 year, 2 months ago (2007-09-14 08:56:00)
by Laurence Davis
Hi I'm trying to select data from a mirrored database situated on a SQL2k5 server, via a linked server on SQL2k. I can select the data fine using SQLOLEDB but it's not aware of the mirroring so if the DB fails-over it errors. To get around this, I installed SQLNCLI.msi to install the SQL2k5 provider and created a linked server like this: exec sp_...
Started 2 weeks, 3 days ago (2008-11-17 08:11:00)
by VMSSanthosh
Hi Our databases have so many bulk loads and we enabled mirroring in our databases. For mirroring the databases should be in full recovery model. In this situation how we can truncate our abnormal growth of log files.. its not simple to stop the mirroring. truncate the log files by changing the recovery model and start the mirroring process from the begining. http://msdn.microsoft.com/...
|
|
Hot threads for last week on Database Mirroring::
Started 1 week ago (2008-11-27 11:46:00)
by Manian.R
Hi Experts, When Create Mirror Database Server, Where need to store the Transaction Log backup file? I took FULL Backup of my Primary Database, and I restored at my Mirror Server also. When I try to create a Mirror Database, I am getting the below error Missage: "The remote copy of database "<db_name>" has not been rolled forward to a point in time that is encompassed in ...
Started 5 days, 23 hours ago (2008-11-28 17:51:00)
by JoeSchmoe115
Can 32-bit witness be used with 64-bit primary and mirror for SQL Server 2005? Can witness be less powerful than primary/mirror? Does transactional information travel via witness or it only "pings" primary and mirror from time to time?
Started 1 week ago (2008-11-26 22:46:00)
by S Sedgwick
Hi Everyone! No doubt this get's asked quite often .. feedback on some options. A while back we implemented TLS to replicate our core database (then 30GB) across a 1mb DSL link to a secondary server. This has been working quite well. Recently we have continued to have issues with long delays in restore times which just can not restore the logs quick enough. Our database is ...
Started 4 weeks, 1 day ago (2008-11-05 02:09:00)
by pinoyz
How to make a database mirrored? Do i need to code for each database to fill the each database table? Regards noob vb programmer
Started 5 days, 22 hours ago (2008-11-28 18:52:00)
by Prashant Thakwani
Can anyone provide the link that shows that MS supports the DB Mirroring on VMWARE environment, if that is a case ? Thanks Prashant Thakwani
Started 1 week ago (2008-11-26 20:44:00)
by JebSmith
Well, I had an interesting day and I hope someone can point me in the correct direction. We have mirroring installed and working with auto failover - synchronous with a witness and we had a network failure. Mind you we were under very heavy i/o load a the time also. When we moved all the ports for these servers to another switch, the mirror thought it was principal, the principal could ...
|
|
Size: 454 bytes
