Cross Mirroring - Any Good?

Nov 23, 2006

Hi

I��m about to move all our databases from an old lousy server to a brand new HP setup.
I have 8 databases (total of approx 100Gb) and I get 2 BL25p servers and SAN access for them.

Now, I want high availability and I like the idea of mirroring the databases for achieving that. On the other hand I don��t like the idea of the mirror server doing almost nothing while the principal gets the entire load �� seems like a waste of good resources.

But is this really the situation or mirror server also be loaded, just for being the mirror?

Now, if the main load is on the principal would I then benefit from distributing the databases on both servers, so both servers would act like principal and mirror?

What I mean is that server 1 could be principal for DB 1-4 while server 2 would mirror these DB��s and likewise serever 2 would be principal for DB 5-8 and server 1 would mirror them.

Does it make sense? Would I benefit anything from this?

Thx a lot
Nicolaj

View 6 Replies

Cross Geo Database Mirroring

Feb 26, 2008

I'm not personally a DBA or claim to be a database expert, instead I am a software architect who works closely with database architects and DBA's. I'm presently architecting a system where we will have a smart client used in both Europe and the United States from the same database instance.

The system is to be used for performance testing of devices and then the results will be available to management through the same smart client used by test engineers etc. The first release is operational in the United States today with Poland coming online shortly.

Today we are weighing our options between having cross-geo database mirroring or merely having the database server in the United States with application server level caching implemented in Poland and the United States.

The .net framework's Windows Communication Foundation is used with a netTcpBinding and the service layer is asynchronous with the reliableSession option enabled.

Does anyone have any feedback on whether you would go with cross-geo database mirroring or would you use local application servers with possibly some caching capabilities at that layer? Please also describe the benefits and any risks associated with each also...

Thanks in advance,

Doug Holland

View 8 Replies View Related

Mirroring And Cross DB Transactions

Oct 11, 2007

Hi,

I have the following scenario

1. 2 databases A & B which are both mirrored in high safety mode (manual failover)
2. The mirror of A & B are on a separate and remote site in relation to the Principal
3. Some of the application functions insert/update to database A&B as one transaction unit

My query is give the above scenario should I expect any DB incosistency on the mirror Partners for A & B in relation to cross db transactions? I believe not as the update on the Primary should be commited as whole on both Principal databases & mirror databases prior to the client getting confirmation on commit.

Further my understanding is that even in an automated failover with synchronous mirroring there should be no issues with cross DB transactions.

Are my assertions correct?

Thanking you in advance for any feedback.

View 1 Replies View Related

Mirroring And Cross Database Queries

Feb 4, 2008

This may be a newbie question but...

Say for example DatabaseA has failed over to the mirror. Then you call a stored procedure in that database that queries a table on DatabaseB that is on the principle (has not failed). What happens? Is mirroring smart enough to know that? If not, are there workarounds? Perphaps manually failing over the other databases?

Thanks

View 2 Replies View Related

Mirroring :: Log Shipping Cross Different Domains

Oct 27, 2015

SQL Server 2012 SP2 - WIndows 2008 R2.

We are currently doing Mirroring from one domain to another (On a different subnet/network) via

Network1

DomainABCSQLAccount1 - Password1 -----> SQL Server Service Account
DomainABCSQLAccount2 - Password2 -----> SQL Server Agent Service Account

Network2

DomainABCSQLAccount1 - Password1 -----> SQL Server Service Account
DomainABCSQLAccount2 - Password2 -----> SQL Server Agent Service Account

And it works. We are planning to do the Log shipping but this time different Domain but same userID and Password

Network1

DomainABCSQLAccount1 - Password1 -----> SQL Server Service Account
DomainABCSQLAccount2 - Password2 -----> SQL Server Agent Service Account

Network2

DomainDEFSQLAccount1 - Password1 -----> SQL Server Service Account
DomainDEFSQLAccount2 - Password2 -----> SQL Server Agent Service Account

Is this possible without TRUST between the domains ?

View 3 Replies View Related

Database Mirroring | Can Witness Live On Mirroring Server?

May 3, 2008

Server A = primary SQL DBs (mirroring origination)
Server B = failover SQL DBs (mirroring destination)

For database mirroring a witness is required.
Can the witness live in another instance of SQL on server B?

View 7 Replies View Related

Mirroring :: Database Mirroring Changes In Application

Oct 12, 2015

Using SQL Server 2008, we would like propose mirroring between two servers of a critical database. Since we initiate, may require to clarify on its purpose and also required changes from application end.Any changes required from OS Level? (I believe both servers IP or Host name should be added in host entries. Mirroring ports should be allowed/open including Principal and mirror server IP Addresses): Windows Team.Any changes required from Application? (Instance name, authentication: user name and its password should be added in web config files): Application Team.Any changes required from Network Team?Also for mirroring both the principal and mirror servers should be with same version, does it only mean SQL Server 2008 versions are enough or does it also mean to say build numbers 10.00.4000 should also be same.URL....

View 5 Replies View Related

Mirroring :: Setting Up Mirroring With Different Vlans?

Sep 15, 2015

I need to set up asyncronous data replication across two clustered instances of SQL 2012 across 2 Datacenters. Both the datacenters have a common domain however the vlans are different. There are only 3 small databases on the primary instance.

any issue in setting up mirroring in this case as vlans are different.

Operating system is Windows 2012.

View 2 Replies View Related

Good SQL Book

May 30, 2007

hello
i am just starting to learn sql and know the basics, but now im looking for a good book to learn some more. A book that covers stored procedure would be very useful. If possible a book with q and a would be very good because i feel this tests if u understand what was just explaned. but if there is a good book without this it is ok. All sugestions welcome

NubNub

View 1 Replies View Related

What Is Good Approch

Aug 7, 2007

hii am using vs2005 for development of web application for reporting with sqlexpress05 as back end .later when project is ready for deployment i have to deploy the project on remote hosting server where i have limited access and sqlserver2000 database to use.i want to ask is there are any limitation or problem of sqlexpress while deploying it on remote sqlservre 2000.and should i have to to continue with sqlexpress as back end.is there any problems for using dynamic database connections(by using smart tags) other than programaticaly connecting database to asp.net ie by writing code.i am new in developmentplease guide me, please guide

View 2 Replies View Related

Good Searching

Jan 7, 2008

hello all..i have make a searching, but is not good. my code like that:Public Class getall Public Function getitem(ByVal id As String) As DataSet Dim con As SqlConnection = New SqlConnection("Data Source=BOYsqlexpress;Initial Catalog=GAMES;User ID=ha;Password=a") Dim ds As New DataSet() Dim adapter As New SqlDataAdapter("select * from [item] where name like '%" & id & "%'", con) Try con.Open() adapter.Fill(ds, "user") Return ds Catch ex As Exception Console.Write(ex.Message) Finally con.Close() con = Nothing End Try ' Next Return ds End Functionand class my item in database is containning dragon ball 3, counter strikeif i insert dragon, it can display dragon ball 3.but if i insert dragon 3, it not display dragon ball 3.it should display dragon ball 3 .how should i change my code?thx...

View 1 Replies View Related

WHERE (@ColName=...) - Not Good?!..

Dec 12, 2003

Hi, gurus!
Of course, you know that this:

... WHERE (COLUMNNAME = @PARAMETER)

works perfectly, but the opposite - when I need to pass
a column name as a parameter - the SQL Server 2000 cursing me...

I was designing some stored procedures and here is what I need:

... WHERE (@COLUMNNAME = 1)

^^^ I need to use a different column names here, so I decided to use
a parameter, but it does not even budge. Of course, I can use workaround:

IF @COLUMNNAME = 'External' THEN
BEGIN
SELECT ... WHERE (External = 1)
END

But, I SO! do not want to do it 9 times - I have 9 column names
to check...

Maybe, there is another way to do it?..

Thanks,
Cheers!

View 3 Replies View Related

I've Never Been Good With Relationships

Feb 15, 2004

I'm having some trouble working out how to query some data. Rather than explain up front, here's some examples of what I want to achieve:

*******************************************************

I've got a structure which looks vaguely like this:

[ANCESTORS]

Grandparent
Parent
Child

If limit by grandparents, then I only get the lineage for that particular grandparent. I.e.:

SELECT *
FROM [ANCESTORS]
( some sort of joins here )
Where Grandparent.Name = 'Cybill'

This would return all of the children of 'Cybill' and their children. Now, if I use the following query:

SELECT *
FROM [ANCESTORS]
( some sort of joins here )
Where Child.Name = 'Jean'

This would return Jean's parents + the parents of Jean's parents (Jean's grandparents).

Likewise, if I enter:

SELECT *
FROM [ANCESTORS]
( some sort of joins here )
Where Parent.Name = 'Ron'

Then I would get Ron's parents and also his children.

*******************************************************

So, as you can see, at first it appears that I'm after a LEFT JOIN - meaning that the grandparents don't need to have child records to be returned, but, then it turns out that I need INNER JOINS - to limit grandparents when I choose children.

Can anybody see my dilemma here?

Mark-up ASP.net posts here
MarkItUp.com

View 10 Replies View Related

MCDBA Is Good For DBA?

Jan 21, 2001

Hi All

I am planning to do MCDBA, whether it'd good for DBA's, is't worth of doing or not, Please send me your comments.

Thanks

Regards
Ram

View 5 Replies View Related

Good Book For Using DTS?

Aug 23, 2000

I have been using DTS somewhat, but I would like to read a good discussion (with cpmplex examples) of it.

Anyone found either a book on DTS or a good section in a book?

Thanks,
Judith

View 1 Replies View Related

Any Good DTS Books

Sep 30, 2002

Does anyone know of any good books on DTS? I am currently using SQL 7.

Thanks in advance

View 2 Replies View Related

Any Good Books

Sep 14, 1998

Hi there,

Any good books to Know the internals of MS-SQL server 6.5

Thanks
Vivek

View 2 Replies View Related

What's A Good SQL Editor?

Oct 28, 2004

Hi everyone

I'm wondering if there's a better SQL Editor than MS Query Analyzer on the market? I like a lot of the functionality provided by QA but want extra stuff like you get in VB6: intelli-sense (sytanx prompting), auto-complete (CTRL+Space provides list of sp's and tables, etc.) plus any other time saving features.

I've tried a few products but nothing quite hits the mark. Is there a program you use and recommend I trial?

Cheers - Andy

View 14 Replies View Related

Good SQL Query

Mar 7, 2005

Folks, i've got a table with a column; ACCOUNT VARCHAR(30). All the values numeric though. (leave abt the datatype yet).
The column is clustered indexed.

SELECT * FROM MYTABLE WHERE LEFT(ACCOUNT,3)='123'
execution plan shows CLUSTERED INDEX SCAN.

SELECT * FROM MYTABLE WHERE ACCOUNT LIKE '123%'
execution plan shows CLUSTERED INDEX SEEK.

How, why. Why doesn't the optimizer works good for the first query?

Howdy!

View 7 Replies View Related

If Your Good With SQL Queries - Please Help

Apr 9, 2008

Hi, ive got some work to do on SQL queries, the scenario is below and at the bottom is my attempt at answering in the questions:
Could somebody simply tell me if the answer at the bottow are correct, if not what I have done wrong.

A local company that produces machine parts has decided to develop an in-house database system. They have identified the following tables: -

tblOrders OrderNo, CustomerNo, Date, OrderTotal

tblCustomers CustomerNo, Name, Street, Town, County, Postcode

tblParts PartNo, Description, UnitCost

tblItems OrderNo, PartNo, Quantity, ItemTotal

Create SQL queries to produce the following: -

a) Details of all orders over £1000 sorted by customer
number.

b) A list of all part descriptions and their quantities appearing on order 39

c) Delete all orders placed by customers in
Wrexham.

d) Archive all orders placed by customer Clarke into a new table called
tblArchive.

e) Increase the price of all parts whose description includes the
word “washer” by 4%.

These are my answer, which im not too sure if they are correct. If any1 could tell me if there correct or not that would be great, thanks.

a)
SELECT *
FROM tblOrders
ORDERBY CustomerNO
WHERE OrderTotal > 1000

b)
SELECT tblParts.PartNo, tblParts.Description, tblItems.Quantity
FROM tblItems INNER JOIN tblParts ON tblItems.PartNo = tblParts.PartNo;
WHERE OrderNo = 39

c)
DELETE tblOrders.*
FROM tblOrders INNER JOIN tblCustomers ON tblOrders.CustomerID = tblCustomers.CustomerID
WHERE Town = “Wrexham”

d)
INSERT INTO tblArchive
SELECT *
FROM tblOrders INNER JOIN tblCustomers ON tblOrders.CustomerID = tblCustomers.CustomerID
WHERE Name = “Clarke”

e)
UPDATE tblParts
SET UnitCost = [UnitCost]*1.04
WHERE Description LIKE “*washer” or Description LIKE “washer*” or
Description LIKE “*washer*”

Please help :)

View 1 Replies View Related

MS SQL Server Is Good With ...?

Feb 13, 2004

Hi,

I'm about 6 weeks into SQL and SQL Server (7) - I was wondering whether you could share your opinions about which language to use as a programming tool for developing apps for & with SQL Server. I'm choosing between C++ (Visual) or JAVA.

I already know C and the DB-Libe contains a lot of it but I'm kinda trying to expand some horizons. I'm ok with either C++/VC++ or JAVA but I only have time to learn (or be good at) one.

Any suggestions? (I'd like to hear what you think even if you say neither C++ or JAVA - maybe VB? What's easy and marketable is what matters most.)

Thanks.

View 1 Replies View Related

Need A Good Book...

Apr 27, 2004

I've been a SQL Server dba for 5 or 6 years now. With the upcoming release (eventually, I'm sure) of Yukon/SQL2005, I've read that it's important for DBA's to pick up one of the .NET languages - I've figured, I'll try to learn VB.NET - I've had a little exposure to it, and can usually figure out what's going on in VB code I've read - however, I seriously doubt I could write anything in it from scratch - I want to learn it in a bad way - can you all recommend any self-paced books that will walk me thru it? I've never had any formal training with it, don't know a class from a DLL....Thanks in advance for your help!!

View 3 Replies View Related

Need Good Idea

Jul 23, 2005

Hi guysWe have a following problem. For security reasons in each table in ourDB we have addition field which is calculated as hash value of allcolumns in particular row.Every time when some field in particular row is changed we create andcall select query from our application to obtain all fields for thisrow and then re-calculate and update the hash value again.Obviously such approach is very ineffective, the alternative is tocreate trigger on update event and then execute stored procedure whichwill re-calculate and update the hash value. The problem with thisapproach is that end user could then change the date in the tables andthen run this store procedure to adjust hash value.We are looking for some solution that could speed up the hash valueupdating without allowing authorized user to do itThanks in advance,Leon

View 6 Replies View Related

Good SQL Book?

Jul 20, 2005

hello, for a new job i might have to learn SQL. i've neverworked with databases or SQL, so i'll need to learn. cananybody advice me on what would be a good book to learnfrom? i'm quite an experienced programmer, so it doesn'thave to be a dummies guide, and preferably not a bulky booklike the "SQL bible" or something.oh, one of my 'favourite' computer books of all times is"thinking in Java" by bruce eckel, to give you an idea.mike--not sure if there's a better group to ask these questions

View 4 Replies View Related

I'd Like To Get A Good Book Of SQL...

Apr 20, 2006

Would all of you give me a suggestion of valuable book in terms of SQL ??

I confused what kind of SQL book is going to be good for me to study since

I begin to jump into MS-SQL...

Furthermore, I'd know that various level of book as begginer, intermediate , advance...

Thanks for your help in advance..

View 6 Replies View Related

Which Version Of SQL Is Good For Me?

Mar 11, 2008

Hi all,
I have couple of databases in access which i want to spilit them in backend and frontend, and then put the backend( just tables) in sql and keep frontend in access.
which version of sql is good for me to do that?
by the way there are more than 10 users want to access the front end for dataentry.
all the databases and the sql server can be in the same server.

thanks in advance,
Azi

View 6 Replies View Related

T-sql Cross Tab

Jul 20, 2004

I should've posted this thread here....

http://www.dbforums.com/t1005070.html

View 1 Replies View Related

Cross Tab?

May 18, 2004

View 1 Replies View Related

Cross Tab

Jun 17, 2008

Is it possible change to cross tab using code?

Before code:

NAMETYPEVALUE
AAAHEIGHT66
AAAWEIGHT198

After code

NAMEHEIGHTWEIGHT
AAA66198

View 5 Replies View Related

Cross Tab

Oct 20, 2006

Hi,
I'm just starting to learn SQL, just on the querying side and have what I think is quite a tricky function. It may be simple for you guys.

I want to make a report based on three tables. Enrolment, Course and Student. Its pretty easy until I need to crosstab it.

It's more complex than this (more fields but this gives the gist) Basically I want AcademicYearId, StudentID, coursecode, completionstatusid which would give the following.

AcademicYearId StudentId coursecode completionstatusid
05/06 912345 FWFT1 CONTINUING
05/06 914587 FWFT1 CONTINUING
05/06 987654 FWFT1 WITHDRAWN
05/06 954376 FWFT1 CONTINUING
05/06 934512 FWFT1 TRANSFERRED
05/06 923000 FWFT1 TRANSFERRED
04/05 945109 FWFT1 COMPLETED

I have managed to group it by academicyearid, coursecode and completionstatusid and done the counts ok but I want to twist the completionstatusid so each type of status has its own column like this

Year CourseCode Students Continuing Withdrawn Transferred Completed
05/06 FWFT1 6 3 1 2 0
04/05 FWFT1 1 0 0 0 1

Can anyone help me with the the extra columns please.

View 12 Replies View Related

Cross Tab??

Jul 20, 2005

thought my question was misinterpreted.actual table can be smaller or larger. but,within a procedure need to turn a created #temptablesimilar to(examid is in asc order):(id, p/f, examid, examname)1 f xxxx xxxxx1 f xxxx xxxxx1 f xxxx xxxxx2 p3 p4 f xxxx xxxxx4 f xxxx xxxxx4 f xxxx xxxxx4 f xxxx xxxxx4 f xxxx xxxxx4 f xxxx xxxxx4 f xxxx xxxxx(note, id = 4 has 7 failed exams).to a table with up to five columns of failedexamnames:1 f xxxxx xxxxx xxxxx2 p2 p4 f xxxxx xxxxx xxxxx xxxxx xxxxxcan get rid of exameid if helps.--Sent by ricksql from yahoo subpart from comThis is a spam protected message. Please answer with reference header.Posted via http://www.usenet-replayer.com/cgi/content/new

View 2 Replies View Related

Web Developer Looking For Good SQL Book

Jan 6, 2007

I'm looking to buy a book about SQL, T-SQL, stored procedures, etc. I'm a web developer, so I don't need a book for a SQL Server administrator. I need a book that tells me what I as a developer need to know about SQL. I'm currently using Visual Studio, SQL Server 2005, ASP.NET 2.0, and VB.NET (and fairly new to all of those) if that makes any difference. The bulk of my web developing experience has been with PHP and MySQL so this is new territory for me. I hope all that makes sense. I would appreciate any suggestions for such a book.
Thanks!
-Mathminded
p.s. I bought a bunch of Wrox books and haven't had them long enough to decide if I like them: "Professional ASP.NET 2.0", "Professional ASP.NET 2.0 Security, Membership, and Role Management", "ASP.NET 2.0 Website Programming", and "Visual Basic 2005". I thought I'd check with the experts before investing in another book. :-)

View 2 Replies View Related

A Good SSIS Book?

Jan 7, 2007

I am new to SQL2005 and have been given the task of writing some SSIS packages to import some CSV files.
I need to cleans the data as it is imported from my CSV files before it reaches my SQL DB.
I am currently Googling the internet to discover how to do this.
Can anyone recommend a good SSIS book?
I am a C# developer, so a book that has lots of SSIS C# examples would be good.
Any help appreciated.
Regards,
Paul.

View 3 Replies View Related