| Author |
 Topic  |
|
|
ps2ali
Starting Member
21 Posts |
 Posted - 04/20/2012 : 12:30:31
|
Hi all,
i installed sql server 2008 standard edition on both my windows 2008 r2 standard edition servers ,
its possible to replicate my both databases to ensure availabilty if among the servers is crashed !!! please i need help
IT Engineer |
|
|
russell
Pyro-ma-ni-yak
USA
4967 Posts |
Posted - 04/20/2012 : 12:36:19
|
You want to cluster or replicate?
Failover clustering will protect you against a hardware failure.
Replication, while it can be used as a business continuity strategy, is more typically used for scaling out applications.
You can do both. But if you're looking for protection against a server crash, clustering is usually the way to go. |
 |
|
|
ps2ali
Starting Member
21 Posts |
Posted - 04/20/2012 : 12:46:14
|
i'm looking for availability of my database , but i heard this option is not appeared on windows 2008 standard edition !!!!i'm waiting your suggestion
IT Engineer |
|
|
|
ps2ali
Starting Member
21 Posts |
Posted - 04/20/2012 : 13:11:14
|
exactly i need in the same time replication and clustering ! but those options are available for my package already installed!
IT Engineer |
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 04/20/2012 : 13:11:15
|
Windows failover clustering requirements: http://technet.microsoft.com/en-us/library/dd197454.aspx
SQL Server Standard Edition limits the number of nodes to 2 for failover clustering: Link
Database mirroring is another availability option that does not require clustering, but it only works at the database level. So if you had a hardware failure, each database would have to fail over individually.
And relax on the exclamation points, it won't make us answer the question faster. |
|
|
|
Sachin.Nand
Flowing Fount of Yak Knowledge
2937 Posts |
Posted - 04/21/2012 : 09:50:04
|
First you need to have windows clustering in place before you can have sql clustering and windows server 2008 standard edition does NOT support windows clustering.
So until you dont upgrade the windows edition to enterprise clustering is out of picture.
After Monday and Tuesday even the calendar says W T F .... |
|
|
|
ps2ali
Starting Member
21 Posts |
Posted - 04/22/2012 : 17:33:48
|
@robvolk : how can i implement option :"database mirroring" and what does mean "database level"
IT Engineer |
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
|
|
ps2ali
Starting Member
21 Posts |
Posted - 04/24/2012 : 10:48:24
|
but mirroring not supporting FILESTREAM!
IT Engineer |
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 04/24/2012 : 11:10:04
|
I guess you'll have to go with replication then.
And please, give some of the other punctuation marks a chance, you don't have to end everything with an exclamation point. |
|
|
|
ps2ali
Starting Member
21 Posts |
Posted - 04/24/2012 : 11:34:57
|
okay robvolk :)
IT Engineer |
|
|
|
Sachin.Nand
Flowing Fount of Yak Knowledge
2937 Posts |
Posted - 04/24/2012 : 11:42:29
|
I would rather suggest you to go with Log Shipping.But if you go ahead with replication then I hope you are aware of the prerequisite for setting up replication.
After Monday and Tuesday even the calendar says W T F .... |
|
|
|
Sachin.Nand
Flowing Fount of Yak Knowledge
2937 Posts |
|
| |
Topic |
|
sql server standard edition clustering
