sql server standard edition clustering

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

sql server standard edition clustering

Author

Topic

ps2ali
Starting Member

21 Posts

Posted - 2012-04-20 : 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

5072 Posts

Posted - 2012-04-20 : 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 - 2012-04-20 : 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 - 2012-04-20 : 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

15732 Posts

Posted - 2012-04-20 : 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

2937 Posts

Posted - 2012-04-21 : 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 - 2012-04-22 : 17:33:48

@robvolk : how can i implement option :"database mirroring" and what does mean "database level"

IT Engineer

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-04-23 : 07:06:25

There's an overview here: http://msdn.microsoft.com/en-us/library/ms189852.aspx

ps2ali
Starting Member

21 Posts

Posted - 2012-04-24 : 10:48:24

but mirroring not supporting FILESTREAM!

IT Engineer

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-04-24 : 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 - 2012-04-24 : 11:34:57

okay robvolk :)

IT Engineer

Sachin.Nand

2937 Posts

Posted - 2012-04-24 : 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

2937 Posts

Posted - 2012-04-24 : 11:50:24

Maybe you should read this

http://msdn.microsoft.com/en-us/library/bb895334.aspx

After Monday and Tuesday even the calendar says W T F ....

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources