Hi,
I'm writing a proposal for a DR solution for a SQL based application. I've
been looking at clustering, database mirroring, etc. Has anyone come across
any documentation discussing the pro's and cons of the various options
available?
Thanks
Clustering has a distance limitation. Database mirroring is not scalable
beyond 10 or so databases but has no clustering limitation. Clustering
requires expensive hardware. Database Mirroring does not. Database
Mirroring is available on developer and Enterprise and above versions of SQL
Server 2005. Clustering is available on EE versions of SQL 7 and above, and
also on SQL Server Standard in SQL 2005.
Database Mirroring does add some latency to each transaction and as it is
hostbased it works best for low loads on SQL Server. If you have high cpu
utilization your database mirroring solution is likely to fail.
You neglect to mention log shipping and replication in your list of DR
solutions. Both of these word well as well. Log shipping does increase your
exposure to data loss, and is not really scalable beyond a certain size and
number of databases. Replication replicates on an object level and has no
limitation. Failback can be complex.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hardmandez" <Hardmandez@.discussions.microsoft.com> wrote in message
news:F2DB4016-3D90-4438-B49D-B7B4F76CE03D@.microsoft.com...
> Hi,
> I'm writing a proposal for a DR solution for a SQL based application.
> I've
> been looking at clustering, database mirroring, etc. Has anyone come
> across
> any documentation discussing the pro's and cons of the various options
> available?
> Thanks
>
|||Also check out Stretch Clustering, which can be configured for SQL Server
failover clusters. This can extend the distance limitation mentioned
previously.
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog05.mspx
Anthony Thomas
"Hardmandez" <Hardmandez@.discussions.microsoft.com> wrote in message
news:7E081208-21B9-43D1-A241-A2B15E118575@.microsoft.com...
> Thanks for that Hilary, some good points there. Still to get to log
shipping
> and replication in my proposal. SQL isn't really my area of expertease so
> one more question, does SQL come with replication capabilities out of the
box[vbcol=seagreen]
> or when you talking about replication are you refering to products like
> Neverfail?
> "Hilary Cotter" wrote:
SQL[vbcol=seagreen]
and[vbcol=seagreen]
is[vbcol=seagreen]
cpu[vbcol=seagreen]
your[vbcol=seagreen]
and[vbcol=seagreen]
no[vbcol=seagreen]
|||I also have heard that rumor that Neverfail licenses their replication
from DoubleTake, however, this post from the VP of Product Management
from Neverfail denies that is the case. How long ago did Neverfail
tell you they licensed from DoubleTake? I suppose it may have been
true at one point, but apparently no longer.
[url]http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/375548336a1c2343/f7328f5f4ef3dfc1?lnk=st&q=Neverfail+DoubleTake&rnu m=5&hl=en#f7328f5f4ef3dfc1[/url]
If you ever compare the two products in terms of performance of the
replication, I think you will find that Neverfail's replication is much
more efficient. It is surprising that DoubleTake, being one of the
oldest data replication products around, really is behind everyone else
in terms of performance of their replication IMHO.
David A. Bermingham, MCSE, MCSA:Messaging
Senior Systems Engineer
www.steeleye.com
Hilary Cotter wrote:[vbcol=seagreen]
> Hi David.
> Last time I spoke with Neverfail they told me they licensed their technology
> from Doubletake. You are correct about DFS and Doubletake. My mistake, DFS
> does provide very similar services to Doubletake, and in some cases DFS is a
> better choice than Doubletake (for example in file replication).
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "daveberm" <david.bermingham@.steeleye.com> wrote in message
> news:1161871846.621466.57800@.m7g2000cwm.googlegrou ps.com...
Showing posts with label solution. Show all posts
Showing posts with label solution. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
Proper way to rename ASPNETDB.MDF? Custom provider the solution?
ASP.NET 2.0...
What is the proper way to rename the ASPNETDB.MDF to another name, such as TEST_ASPNETDB.MDF?
I know you can rename the db in the IDE, BUT, there are other places you need to change so that ASPNETDB.MDF isn't recreated. Do I have to make a custom SQLExpress provider or something to that effect?
Any examples? Thanks...
Change the connection strings in web.config:
<?xmlversion="1.0"?>
<configuration>
<connectionStrings>
<clear/>
<addname="LocalSqlServer"connectionString="Data Source={Machine name};Initial Catalog=TEST_ASPNETDB;{Rest of connect string here}"providerName="System.Data.SqlClient"/>
</connectionStrings>
Tuesday, March 20, 2012
Project opening - XML Document Error (118, 17)
While openeing the solution file (.sln), I got the following error:
"There is an error in XML document (118, 17)."
I am trying to open a project of SQL Server 2000 - Reporting Services.
Don't know what had happened actually.Hi,
Have you edited or changed anything on the rdl file / sln file.?
Amarnath
"Rohit Jain" wrote:
> While openeing the solution file (.sln), I got the following error:
> "There is an error in XML document (118, 17)."
> I am trying to open a project of SQL Server 2000 - Reporting Services.
> Don't know what had happened actually.|||Thanks Amarnath,
Yeah I have found the solution. Actually the error was occurring due to a
change in .rptproj file, and by this change the file itself got corrupted.
Thanks for your response Amarnath.
But stll I have 1 query - where I can found that XML document for which the
error was displayed.
"Amarnath" wrote:
> Hi,
> Have you edited or changed anything on the rdl file / sln file.?
> Amarnath
> "Rohit Jain" wrote:
> > While openeing the solution file (.sln), I got the following error:
> >
> > "There is an error in XML document (118, 17)."
> >
> > I am trying to open a project of SQL Server 2000 - Reporting Services.
> >
> > Don't know what had happened actually.
"There is an error in XML document (118, 17)."
I am trying to open a project of SQL Server 2000 - Reporting Services.
Don't know what had happened actually.Hi,
Have you edited or changed anything on the rdl file / sln file.?
Amarnath
"Rohit Jain" wrote:
> While openeing the solution file (.sln), I got the following error:
> "There is an error in XML document (118, 17)."
> I am trying to open a project of SQL Server 2000 - Reporting Services.
> Don't know what had happened actually.|||Thanks Amarnath,
Yeah I have found the solution. Actually the error was occurring due to a
change in .rptproj file, and by this change the file itself got corrupted.
Thanks for your response Amarnath.
But stll I have 1 query - where I can found that XML document for which the
error was displayed.
"Amarnath" wrote:
> Hi,
> Have you edited or changed anything on the rdl file / sln file.?
> Amarnath
> "Rohit Jain" wrote:
> > While openeing the solution file (.sln), I got the following error:
> >
> > "There is an error in XML document (118, 17)."
> >
> > I am trying to open a project of SQL Server 2000 - Reporting Services.
> >
> > Don't know what had happened actually.
Monday, February 20, 2012
Program Connection Problem
Hi there,
I really hope that someone recognises this problem and can point me in the
direction of a solution.
We have SQL Server 2000 running on a server at our head office. We have a
program that runs in other sites that connect to the server via a VPN
connection HO. The program has been running perfectly for about a year now
without any problems. A few weeks ago, one machine in one of our sites
stopped opening a connection and has refused to open one ever since. We
hadn't had any problems anywhere else so we swapped the machine with a newer
one and thought nothing else about it. However, a couple of days ago another
machine in another site did the same thing. It simply refuses to open a
connection to the server. The error it throws is "SQL Server does not exist
or access denied". This strikes me as strange because he machine can ping
the sql server happily and it has no problems with the rest of its network
connectivity and the connection string uses the server admin user and
password. I've tried changing the machine IP address and HostName but that
has had no effect. The machine is running Windows 98 SE.
Now, I am pretty sure that there is nothing wrong with the program because
it has been running perfectly for ages and hasn't changed for nearly a year.
The program is running on about 20 identical 98 boxes in 15 sites. The first
machine to go was probably the busiest user of the program and this second
one is probably next.
So I'm thinking that this must be a SQL issue but we really don't have
anyone that knows that much about it. What I do know is that, in general,
the server is running ok. The program in question is probably the smallest
data-wise and has very little traffic, we have other much more complex
databases and programs running 24/7 on the server and they are all ok.
So, I guess the leading question is - does anyone have any ideas? Is there
some kind of connection log that has maxed out or something like that?
Any pointers would be fantastic.
Cheers
C-Ya Aly
Do client tools like UDL, osql and isql work from this problem machine? Can
this problem client machine ping any other sql servers in your network?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
I really hope that someone recognises this problem and can point me in the
direction of a solution.
We have SQL Server 2000 running on a server at our head office. We have a
program that runs in other sites that connect to the server via a VPN
connection HO. The program has been running perfectly for about a year now
without any problems. A few weeks ago, one machine in one of our sites
stopped opening a connection and has refused to open one ever since. We
hadn't had any problems anywhere else so we swapped the machine with a newer
one and thought nothing else about it. However, a couple of days ago another
machine in another site did the same thing. It simply refuses to open a
connection to the server. The error it throws is "SQL Server does not exist
or access denied". This strikes me as strange because he machine can ping
the sql server happily and it has no problems with the rest of its network
connectivity and the connection string uses the server admin user and
password. I've tried changing the machine IP address and HostName but that
has had no effect. The machine is running Windows 98 SE.
Now, I am pretty sure that there is nothing wrong with the program because
it has been running perfectly for ages and hasn't changed for nearly a year.
The program is running on about 20 identical 98 boxes in 15 sites. The first
machine to go was probably the busiest user of the program and this second
one is probably next.
So I'm thinking that this must be a SQL issue but we really don't have
anyone that knows that much about it. What I do know is that, in general,
the server is running ok. The program in question is probably the smallest
data-wise and has very little traffic, we have other much more complex
databases and programs running 24/7 on the server and they are all ok.
So, I guess the leading question is - does anyone have any ideas? Is there
some kind of connection log that has maxed out or something like that?
Any pointers would be fantastic.
Cheers
C-Ya Aly
Do client tools like UDL, osql and isql work from this problem machine? Can
this problem client machine ping any other sql servers in your network?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Program Connection Problem
Hi there,
I really hope that someone recognises this problem and can point me in the
direction of a solution.
We have SQL Server 2000 running on a server at our head office. We have a
program that runs in other sites that connect to the server via a VPN
connection HO. The program has been running perfectly for about a year now
without any problems. A few weeks ago, one machine in one of our sites
stopped opening a connection and has refused to open one ever since. We
hadn't had any problems anywhere else so we swapped the machine with a newer
one and thought nothing else about it. However, a couple of days ago another
machine in another site did the same thing. It simply refuses to open a
connection to the server. The error it throws is "SQL Server does not exist
or access denied". This strikes me as strange because he machine can ping
the sql server happily and it has no problems with the rest of its network
connectivity and the connection string uses the server admin user and
password. I've tried changing the machine IP address and HostName but that
has had no effect. The machine is running Windows 98 SE.
Now, I am pretty sure that there is nothing wrong with the program because
it has been running perfectly for ages and hasn't changed for nearly a year.
The program is running on about 20 identical 98 boxes in 15 sites. The first
machine to go was probably the busiest user of the program and this second
one is probably next.
So I'm thinking that this must be a SQL issue but we really don't have
anyone that knows that much about it. What I do know is that, in general,
the server is running ok. The program in question is probably the smallest
data-wise and has very little traffic, we have other much more complex
databases and programs running 24/7 on the server and they are all ok.
So, I guess the leading question is - does anyone have any ideas? Is there
some kind of connection log that has maxed out or something like that?
Any pointers would be fantastic.
Cheers
C-Ya AlyDo client tools like UDL, osql and isql work from this problem machine? Can
this problem client machine ping any other sql servers in your network?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
I really hope that someone recognises this problem and can point me in the
direction of a solution.
We have SQL Server 2000 running on a server at our head office. We have a
program that runs in other sites that connect to the server via a VPN
connection HO. The program has been running perfectly for about a year now
without any problems. A few weeks ago, one machine in one of our sites
stopped opening a connection and has refused to open one ever since. We
hadn't had any problems anywhere else so we swapped the machine with a newer
one and thought nothing else about it. However, a couple of days ago another
machine in another site did the same thing. It simply refuses to open a
connection to the server. The error it throws is "SQL Server does not exist
or access denied". This strikes me as strange because he machine can ping
the sql server happily and it has no problems with the rest of its network
connectivity and the connection string uses the server admin user and
password. I've tried changing the machine IP address and HostName but that
has had no effect. The machine is running Windows 98 SE.
Now, I am pretty sure that there is nothing wrong with the program because
it has been running perfectly for ages and hasn't changed for nearly a year.
The program is running on about 20 identical 98 boxes in 15 sites. The first
machine to go was probably the busiest user of the program and this second
one is probably next.
So I'm thinking that this must be a SQL issue but we really don't have
anyone that knows that much about it. What I do know is that, in general,
the server is running ok. The program in question is probably the smallest
data-wise and has very little traffic, we have other much more complex
databases and programs running 24/7 on the server and they are all ok.
So, I guess the leading question is - does anyone have any ideas? Is there
some kind of connection log that has maxed out or something like that?
Any pointers would be fantastic.
Cheers
C-Ya AlyDo client tools like UDL, osql and isql work from this problem machine? Can
this problem client machine ping any other sql servers in your network?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Program Connection Problem
Hi there,
I really hope that someone recognises this problem and can point me in the
direction of a solution.
We have SQL Server 2000 running on a server at our head office. We have a
program that runs in other sites that connect to the server via a VPN
connection HO. The program has been running perfectly for about a year now
without any problems. A few weeks ago, one machine in one of our sites
stopped opening a connection and has refused to open one ever since. We
hadn't had any problems anywhere else so we swapped the machine with a newer
one and thought nothing else about it. However, a couple of days ago another
machine in another site did the same thing. It simply refuses to open a
connection to the server. The error it throws is "SQL Server does not exist
or access denied". This strikes me as strange because he machine can ping
the sql server happily and it has no problems with the rest of its network
connectivity and the connection string uses the server admin user and
password. I've tried changing the machine IP address and HostName but that
has had no effect. The machine is running Windows 98 SE.
Now, I am pretty sure that there is nothing wrong with the program because
it has been running perfectly for ages and hasn't changed for nearly a year.
The program is running on about 20 identical 98 boxes in 15 sites. The first
machine to go was probably the busiest user of the program and this second
one is probably next.
So I'm thinking that this must be a SQL issue but we really don't have
anyone that knows that much about it. What I do know is that, in general,
the server is running ok. The program in question is probably the smallest
data-wise and has very little traffic, we have other much more complex
databases and programs running 24/7 on the server and they are all ok.
So, I guess the leading question is - does anyone have any ideas? Is there
some kind of connection log that has maxed out or something like that?
Any pointers would be fantastic.
Cheers
C-Ya AlyDo client tools like UDL, osql and isql work from this problem machine? Can
this problem client machine ping any other sql servers in your network?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
I really hope that someone recognises this problem and can point me in the
direction of a solution.
We have SQL Server 2000 running on a server at our head office. We have a
program that runs in other sites that connect to the server via a VPN
connection HO. The program has been running perfectly for about a year now
without any problems. A few weeks ago, one machine in one of our sites
stopped opening a connection and has refused to open one ever since. We
hadn't had any problems anywhere else so we swapped the machine with a newer
one and thought nothing else about it. However, a couple of days ago another
machine in another site did the same thing. It simply refuses to open a
connection to the server. The error it throws is "SQL Server does not exist
or access denied". This strikes me as strange because he machine can ping
the sql server happily and it has no problems with the rest of its network
connectivity and the connection string uses the server admin user and
password. I've tried changing the machine IP address and HostName but that
has had no effect. The machine is running Windows 98 SE.
Now, I am pretty sure that there is nothing wrong with the program because
it has been running perfectly for ages and hasn't changed for nearly a year.
The program is running on about 20 identical 98 boxes in 15 sites. The first
machine to go was probably the busiest user of the program and this second
one is probably next.
So I'm thinking that this must be a SQL issue but we really don't have
anyone that knows that much about it. What I do know is that, in general,
the server is running ok. The program in question is probably the smallest
data-wise and has very little traffic, we have other much more complex
databases and programs running 24/7 on the server and they are all ok.
So, I guess the leading question is - does anyone have any ideas? Is there
some kind of connection log that has maxed out or something like that?
Any pointers would be fantastic.
Cheers
C-Ya AlyDo client tools like UDL, osql and isql work from this problem machine? Can
this problem client machine ping any other sql servers in your network?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Subscribe to:
Posts (Atom)