July 31, 2012 at 2:53 am
Hi Gurus,
Due to some network glitch mirroring connection is disable. Is it possible establish the connection automatically once network connected or should i manually establish a mirroring connection.
I have one more question:
We are planning to mirroring totally 1000 databases to our DR site. I want know approximately how much bandwidth and disk size (Each database is 8 GB) is required.
We are using SQL 2005 standard edition with SP2 and 32 bit OS.
Please advice on this....
Advance thanks.
Pradeep
July 31, 2012 at 3:23 am
pradeep.mohan (7/31/2012)
We are planning to mirroring totally 1000 databases to our DR site. I want know approximately how much bandwidth and disk size (Each database is 8 GB) is required.
No way to answer that, you'll have to test it out per database first.
I do hope those 1000 aren't on the same instance...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 31, 2012 at 5:43 am
We have 2 servers per server 3 instance
Pradeep
July 31, 2012 at 6:08 am
So you have around 200 databases per instance that you plan to mirror. Err, good luck with that...
http://support.microsoft.com/kb/2001270
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 31, 2012 at 6:16 am
Thanks Gil,
Any idea about my first point which i was post early....
Pradeep
July 31, 2012 at 6:18 am
It should reconnect once the network connection becomes available again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 31, 2012 at 6:26 am
How many databases can i run on a single instance?
I read about max on 32 bit, use not more then 10 database, but is there a max on 64 bit servers?
I thought i heard about 32 databases and then you have to make another instance. Is that the case?
Pradeep
July 31, 2012 at 6:40 am
Is it possible to having any data loss during the network failure?
Is it synchronizing all the data's after reconnecting the mirror (network connection becomes available again.
)
Is it required any manual action like full & log backup restoration before establish a connection?
Thanks.
Pradeep
July 31, 2012 at 7:38 am
How many databases you can mirror on a single server relies on many factors such as workload, the number of CPUs, the capabilities of the server. You need to test it with a production workload to see how many databases are feasible with your environment.
You will not lose data during a network outage unless you lose the principal database. All of the transactions not yet mirrored will be preserved in the log file until mirroring reconnects and the transactions are transferred to the mirror.
I highly recommend you get a copy of my book. You can download the ebook version directly from the publisher.
July 31, 2012 at 11:00 am
pradeep.mohan (7/31/2012)
How many databases can i run on a single instance?I read about max on 32 bit, use not more then 10 database, but is there a max on 64 bit servers?
I thought i heard about 32 databases and then you have to make another instance. Is that the case?
Did you read the articles I linked to?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 31, 2012 at 10:34 pm
Yes i read and I'm clearing about 32 bit OS but I'm not clearing about 64 bit
Pradeep
August 1, 2012 at 1:03 am
Those articles cover 64-bit, especially the SQLCAT one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2012 at 4:02 am
Thanks Gil...
One more question
which account belongs to run SQL Service and agent either built-in-account or Trusted domain account.
In out databases both (principal and mirror) domain account only
In SQL Server login using windows authentication.
Pradeep
August 1, 2012 at 7:34 am
Don't understand the question.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2012 at 8:39 am
Who's Gil? The person helping you is named either Gail or GilaMonster. Gil Gerard is not a member of these forums.
The best service account to use for the SQL Server service for mirroring is a non-user domain account.
Viewing 15 posts - 1 through 15 (of 37 total)
You must be logged in to reply to this topic. Login to reply