<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SS2K5 Replication
»
Database Mirroring
38 posts, Page 1 of 4
1
2
3
4
»
»»
Database Mirroring
Rate Topic
Display Mode
Topic Options
Author
Message
pradeep.mohan
pradeep.mohan
Posted Tuesday, July 31, 2012 2:53 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 1:23 AM
Points: 49,
Visits: 153
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.
Pradeep
Post #1337737
GilaMonster
GilaMonster
Posted Tuesday, July 31, 2012 3:23 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687,
Visits: 29,946
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 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1337749
pradeep.mohan
pradeep.mohan
Posted Tuesday, July 31, 2012 5:43 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 1:23 AM
Points: 49,
Visits: 153
We have 2 servers per server 3 instance
Pradeep.
Pradeep
Post #1337811
GilaMonster
GilaMonster
Posted Tuesday, July 31, 2012 6:08 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687,
Visits: 29,946
So you have around 200 databases per instance that you plan to mirror. Err, good luck with that...
http://support.microsoft.com/kb/2001270
http://sqlcat.com/sqlcat/b/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1337826
pradeep.mohan
pradeep.mohan
Posted Tuesday, July 31, 2012 6:16 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 1:23 AM
Points: 49,
Visits: 153
Thanks Gil,
Any idea about my first point which i was post early....
Pradeep.
Pradeep
Post #1337836
GilaMonster
GilaMonster
Posted Tuesday, July 31, 2012 6:18 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687,
Visits: 29,946
It should reconnect once the network connection becomes available again.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1337838
pradeep.mohan
pradeep.mohan
Posted Tuesday, July 31, 2012 6:26 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 1:23 AM
Points: 49,
Visits: 153
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.
Pradeep
Post #1337846
pradeep.mohan
pradeep.mohan
Posted Tuesday, July 31, 2012 6:40 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 1:23 AM
Points: 49,
Visits: 153
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.
Pradeep
Post #1337853
Robert Davis
Robert Davis
Posted Tuesday, July 31, 2012 7:38 AM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 1,558,
Visits: 1,396
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.
My blog: SQL Soldier
Twitter:
@SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring
Post #1337898
GilaMonster
GilaMonster
Posted Tuesday, July 31, 2012 11:00 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687,
Visits: 29,946
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 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1338052
« Prev Topic
|
Next Topic »
38 posts, Page 1 of 4
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
