Anyone deployed stretch clustering ?

Ive come across this article
http://www.microsoft.com/technet/pro...y/hasog05.mspx
and was interested in stretch clustering .. and have one node of my cluster
in a geographic dispersed location ..
Has anyone done that and can elaborate more on the storage section of this
doc.. We have EMC SAN in place and curious on the technology of how to make
those 2 SANs appear to be one SAN to the MSCS cluster.. Basically if i setup
a 3 node cluster with 2 passive.. each of the passive nodes being on
different geographical sites and my priority of failover would be is Prodn
Server A fails, then it would failover to the local passive node and if
thats not available ( due to site failure) then move to passive node on the
other site.. Is this possible ? Love to hear more
Hassan,
You would need to first implement a remote mirroring solution with your SAN.
EMC's solution, SRDF (Symmetrix Remote Data Facility), is one of the only
solutions that has been qualified for geographically dispersed Microsoft
clusters. If you implement SRDF, you should also look into EMC's
SRDF/Cluster Enabler for MSCS product (formerly known as GeoSpan) to
automate the failover to the remote site. It's a nice solution and it works
quite well.
If you're considering a geographically dispersed clustering solution, you
might want to take a look at the following KB article for some of the
restrictions/limitations of such a solution:
http://support.microsoft.com/?id=280743
Regards,
John
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ezMQejIkEHA.1996@.TK2MSFTNGP09.phx.gbl...
> Ive come across this article
> http://www.microsoft.com/technet/pro...y/hasog05.mspx
> and was interested in stretch clustering .. and have one node of my
cluster
> in a geographic dispersed location ..
> Has anyone done that and can elaborate more on the storage section of this
> doc.. We have EMC SAN in place and curious on the technology of how to
make
> those 2 SANs appear to be one SAN to the MSCS cluster.. Basically if i
setup
> a 3 node cluster with 2 passive.. each of the passive nodes being on
> different geographical sites and my priority of failover would be is Prodn
> Server A fails, then it would failover to the local passive node and if
> thats not available ( due to site failure) then move to passive node on
the
> other site.. Is this possible ? Love to hear more
>
>
|||One challenge u may face with stretch is the fact that the IP Heartbeat has
to be on same subnet and have a guaranteed roundtrip of <500ms as per below
http://www.microsoft.com/technet/pro.../geoclust.mspx
Also with 3 node you will need either Datacenter or Windows 2003
Andy.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ezMQejIkEHA.1996@.TK2MSFTNGP09.phx.gbl...
> Ive come across this article
> http://www.microsoft.com/technet/pro...y/hasog05.mspx
> and was interested in stretch clustering .. and have one node of my
cluster
> in a geographic dispersed location ..
> Has anyone done that and can elaborate more on the storage section of this
> doc.. We have EMC SAN in place and curious on the technology of how to
make
> those 2 SANs appear to be one SAN to the MSCS cluster.. Basically if i
setup
> a 3 node cluster with 2 passive.. each of the passive nodes being on
> different geographical sites and my priority of failover would be is Prodn
> Server A fails, then it would failover to the local passive node and if
> thats not available ( due to site failure) then move to passive node on
the
> other site.. Is this possible ? Love to hear more
>
>
sql

Any sample banking database to download?

I am a .net developer, know how to get my data from the database
through SQL. I am getting interested in database design, and am
wondering if there are any sample banking database to download.
Basically, for practice, I would like to design a credit card
company's database, such that users can check their charge history,
payment history, current balance, current balance due, etc., pretty
much functionalities which most credit card services provide online.
Any suggestion about how to get started?
Thank you very much."gnewsgroup" wrote:
> I am a .net developer, know how to get my data from the database
> through SQL. I am getting interested in database design, and am
> wondering if there are any sample banking database to download.
> Basically, for practice, I would like to design a credit card
> company's database, such that users can check their charge history,
> payment history, current balance, current balance due, etc., pretty
> much functionalities which most credit card services provide online.
> Any suggestion about how to get started?
> Thank you very much.
>
Hi
Although not a complete schema
http://www.microsoft.com/sql/editions/express/starterschemas.mspx may give
you parts such as customer management etc. The transaction history is a very
similar situation to a invoice item/detail where each item is a card
transaction.
John|||On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> "gnewsgroup" wrote:
> > I am a .net developer, know how to get my data from the database
> > through SQL. I am getting interested in database design, and am
> > wondering if there are any sample banking database to download.
> > Basically, for practice, I would like to design a credit card
> > company's database, such that users can check their charge history,
> > payment history, current balance, current balance due, etc., pretty
> > much functionalities which most credit card services provide online.
> > Any suggestion about how to get started?
> > Thank you very much.
> Hi
> Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmay give
> you parts such as customer management etc. The transaction history is a very
> similar situation to a invoice item/detail where each item is a card
> transaction.
> John
Very cool. Thank you very much. I will closely study a few of them
and may get an idea.|||On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> "gnewsgroup" wrote:
> > I am a .net developer, know how to get my data from the database
> > through SQL. I am getting interested in database design, and am
> > wondering if there are any sample banking database to download.
> > Basically, for practice, I would like to design a credit card
> > company's database, such that users can check their charge history,
> > payment history, current balance, current balance due, etc., pretty
> > much functionalities which most credit card services provide online.
> > Any suggestion about how to get started?
> > Thank you very much.
> Hi
> Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmay give
> you parts such as customer management etc. The transaction history is a very
> similar situation to a invoice item/detail where each item is a card
> transaction.
> John
Thank you. I downloaded those databases, unzipped. But because they
don't come with the log file (*.ldf), I cannot attach them, and
therefore, cannot use it.
I googled, and found this:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
I followed the method provided over there by BashTheGeek, but could
not succeed. I am using SQL Server 2005 Express and got an error
which says something like I cannot ad hoc change the status of a
database.
I don't know why M$ could not have included the LDF file and make our
newbies' life easier. It's called starter database, right?
Any hint is highly appreciated.|||On Apr 29, 9:53 am, gnewsgroup <gnewsgr...@.gmail.com> wrote:
> On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> > "gnewsgroup" wrote:
> > > I am a .net developer, know how to get my data from the database
> > > through SQL. I am getting interested in database design, and am
> > > wondering if there are any sample banking database to download.
> > > Basically, for practice, I would like to design a credit card
> > > company's database, such that users can check their charge history,
> > > payment history, current balance, current balance due, etc., pretty
> > > much functionalities which most credit card services provide online.
> > > Any suggestion about how to get started?
> > > Thank you very much.
> > Hi
> > Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmaygive
> > you parts such as customer management etc. The transaction history is a very
> > similar situation to a invoice item/detail where each item is a card
> > transaction.
> > John
> Thank you. I downloaded those databases, unzipped. But because they
> don't come with the log file (*.ldf), I cannot attach them, and
> therefore, cannot use it.
> I googled, and found this:
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
> I don't know why M$ could not have included the LDF file and make our
> newbies' life easier. It's called starter database, right?
> Any hint is highly appreciated.
Never mind, at an MSDN forum, one guy says that we when attach the
database, simply remove the log file in the dialog box, and attach
it. When it is attached the database will create a log file. That
was easy.|||On Apr 29, 9:53 am, gnewsgroup <gnewsgr...@.gmail.com> wrote:
> On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> > "gnewsgroup" wrote:
> > > I am a .net developer, know how to get my data from the database
> > > through SQL. I am getting interested in database design, and am
> > > wondering if there are any sample banking database to download.
> > > Basically, for practice, I would like to design a credit card
> > > company's database, such that users can check their charge history,
> > > payment history, current balance, current balance due, etc., pretty
> > > much functionalities which most credit card services provide online.
> > > Any suggestion about how to get started?
> > > Thank you very much.
> > Hi
> > Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmaygive
> > you parts such as customer management etc. The transaction history is a very
> > similar situation to a invoice item/detail where each item is a card
> > transaction.
> > John
> Thank you. I downloaded those databases, unzipped. But because they
> don't come with the log file (*.ldf), I cannot attach them, and
> therefore, cannot use it.
> I googled, and found this:
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
> I don't know why M$ could not have included the LDF file and make our
> newbies' life easier. It's called starter database, right?
> Any hint is highly appreciated.
Never mind, I found at an MSDN forum where one guy says that when we
try to attach the mdf database file, simply remove the log file from
the dialog box and when it is attached, the database will create a log
file for it. That was easy.|||> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
The poster should have been more clear about the scenario in which to use
the sp_configure "allow updates" syntax. This option is not needed at all
when the database has been detached or otherwise cleanly shut down. In fact,
the ability to modify the system catalog, which is what that syntax allows,
is not even allowed in SQL Server 2005, That's why you're getting the error
that you are.
Use either sp_attach_single_file (see
http://msdn2.microsoft.com/en-us/library/ms174385.aspx for an example)
or the following syntax introduced in SQL Server 2005:
CREATE DATABASE <db_name>
ON (FILENAME = '<dir path><file_name.mdf'>')
FOR ATTACH
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"gnewsgroup" <gnewsgroup@.gmail.com> wrote in message
news:c761f2e5-ec29-425a-8a39-7c6395e4d79d@.b64g2000hsa.googlegroups.com...
> On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
>> "gnewsgroup" wrote:
>> > I am a .net developer, know how to get my data from the database
>> > through SQL. I am getting interested in database design, and am
>> > wondering if there are any sample banking database to download.
>> > Basically, for practice, I would like to design a credit card
>> > company's database, such that users can check their charge history,
>> > payment history, current balance, current balance due, etc., pretty
>> > much functionalities which most credit card services provide online.
>> > Any suggestion about how to get started?
>> > Thank you very much.
>> Hi
>> Although not a complete
>> schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmay
>> give
>> you parts such as customer management etc. The transaction history is a
>> very
>> similar situation to a invoice item/detail where each item is a card
>> transaction.
>> John
> Thank you. I downloaded those databases, unzipped. But because they
> don't come with the log file (*.ldf), I cannot attach them, and
> therefore, cannot use it.
> I googled, and found this:
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
> I don't know why M$ could not have included the LDF file and make our
> newbies' life easier. It's called starter database, right?
> Any hint is highly appreciated.|||On Apr 29, 1:01 pm, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
wrote:
> > I followed the method provided over there by BashTheGeek, but could
> > not succeed. I am using SQL Server 2005 Express and got an error
> > which says something like I cannot ad hoc change the status of a
> > database.
> The poster should have been more clear about the scenario in which to use
> the sp_configure "allow updates" syntax. This option is not needed at all
> when the database has been detached or otherwise cleanly shut down. In fact,
> the ability to modify the system catalog, which is what that syntax allows,
> is not even allowed in SQL Server 2005, That's why you're getting the error
> that you are.
> Use either sp_attach_single_file (seehttp://msdn2.microsoft.com/en-us/library/ms174385.aspxfor an example)
> or the following syntax introduced in SQL Server 2005:
> CREATE DATABASE <db_name>
> ON (FILENAME = '<dir path><file_name.mdf'>')
> FOR ATTACH
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
>
OK, that's great. But in the MSDN forum, 2 people were saying how
helpful the answer provided by BashTheGeek was. So that sorta misled
me. :)
So,
CREATE DATABASE <db_name>
ON (FILENAME = '<dir path><file_name.mdf'>')
FOR ATTACH
will take care of the whole thing even without an LDF file?
Let me try it out. But, simply try attaching it after removing the ldf
file is easy, too.|||OK, that's great. But in the MSDN forum, 2 people were saying how
helpful the answer provided by BashTheGeek was. So that sorta misled
me. :)
Yes, you were mislead because the context of their particular scenario (i.e.
the database they were trying to attach had not been cleanly shut down) was
not made clear in the post.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"gnewsgroup" <gnewsgroup@.gmail.com> wrote in message
news:8ee8eec9-4061-43b5-a237-79cfe0ae217e@.34g2000hsh.googlegroups.com...
> On Apr 29, 1:01 pm, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
> wrote:
>> > I followed the method provided over there by BashTheGeek, but could
>> > not succeed. I am using SQL Server 2005 Express and got an error
>> > which says something like I cannot ad hoc change the status of a
>> > database.
>> The poster should have been more clear about the scenario in which to use
>> the sp_configure "allow updates" syntax. This option is not needed at all
>> when the database has been detached or otherwise cleanly shut down. In
>> fact,
>> the ability to modify the system catalog, which is what that syntax
>> allows,
>> is not even allowed in SQL Server 2005, That's why you're getting the
>> error
>> that you are.
>> Use either sp_attach_single_file
>> (seehttp://msdn2.microsoft.com/en-us/library/ms174385.aspxfor an example)
>> or the following syntax introduced in SQL Server 2005:
>> CREATE DATABASE <db_name>
>> ON (FILENAME = '<dir path><file_name.mdf'>')
>> FOR ATTACH
>> --
>> Gail Erickson [MS]
>> SQL Server Documentation Team
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights
>> Download the latest version of Books Online
>> fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
> OK, that's great. But in the MSDN forum, 2 people were saying how
> helpful the answer provided by BashTheGeek was. So that sorta misled
> me. :)
> So,
> CREATE DATABASE <db_name>
> ON (FILENAME = '<dir path><file_name.mdf'>')
> FOR ATTACH
> will take care of the whole thing even without an LDF file?
> Let me try it out. But, simply try attaching it after removing the ldf
> file is easy, too.
>

Any Movement on the 4 gig limit?

We're very interested in having our application use SQL/e but we can't have the 4 gig limit. It makes sense to me that SQL/e simply should not be able to access a file over the network, and then you wouldn't have any reason to put a 4 gig limit on it.

At that point it becomes a very flexible alternative for remote users that need to have a large amount of data (i.e. documents, images etc.) with them.

We'd love to start building an abstraction layer so that we can support both SQL Server and SQL/e so that we can support network and remote users and not have the nightmare that is SQL Server Express installation. (care of the windows installer group's bugs...)

Thanks! Hoping for a favourable answer!

The limit is one of the restrictions on having a free db engine, you might want to look at the workgroup edition of SQL Server 2005. The other option is to have muiltiple database files as the limit is on the size of the database files not the combined engine. You could store archived information in files and keep the production/live data in the current file.

|||Ya, but the point to the whole deal is that the 4 gig limit is not applicable in the case of a single user database scenario like SQL/e because it's specifically there to prevent people from using SSE to share the database and not buy SQL Server.

With SQL Server 2000 we had the personal edition which was $99. That was fine and dandy and I could live with that on client machines. However, that's gone for SQL Server 2005 and as a result it gets incredibly expensive to outfit laptops with a database engine that doesn't have a 4 gig limit.

SQL/e is the perfect way to distribute your application in a smart client (online/offline) environment because it's drag and drop installable instead of the disaster that is SSE installation. And because it's designed for a single user scenario there should be no reason for the 4 gig limit. They should just prevent the APIs from connecting to a datasource on a network device. Problem solved and you get a great little database for distributed applications.

And since this is exactly the scenario that the product was designed for it just makes sense to not have a limit and lock it down.