Solved

SQL Server - Backup server

Posted on 2013-11-12
10
28 Views
Last Modified: 2015-04-17
Dear Experts,

Currently we have SQL Server 2005 Standard Edition installed in a dedicated server.

Now we are planning to have a one more server as a backup server. So that if the primary server down users can continue to get the database access through the proposed new server.

I am newbie for the replication concepts.  Please advice a suitable solution for our requirement.

Thanks in advance,

Regards,

Tajudeen.
0
Comment
Question by:tajudeen_1
  • 7
  • 3
10 Comments
 
LVL 16

Accepted Solution

by:
Shaik M. Sajid earned 500 total points
ID: 39643732
you need to have clusered scenario..

see the article

http://blog.consultdba.com/2010/03/sql-2005-cluster-installation-step-by.html

all the best
0
 
LVL 1

Author Comment

by:tajudeen_1
ID: 39644199
Hi shaiksaj,

Thank you for your reply. I will go through the link.  

Also we are planning to place the server in a different location. There is a leased line connectivity exists to the new location.

So I would like to know is it possible to implement the clustering.

Thanks,

Regards,

Tajudeen.
0
 
LVL 1

Author Comment

by:tajudeen_1
ID: 39656244
Dear Shaiksaj,

Please advice me for my second question.

Thanks in advance,

Regards,

Tajudeen.
0
 
LVL 1

Author Comment

by:tajudeen_1
ID: 39656248
Dear experts,

I need more advice in this regards.

Please help.

Thanks in advance,

Regards,

Tajudeen
0
 
LVL 16

Assisted Solution

by:Shaik M. Sajid
Shaik M. Sajid earned 500 total points
ID: 39658531
no you cant make cluser over leased lane

it's only on premises... by sharing same storage...
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 1

Author Comment

by:tajudeen_1
ID: 39697884
Hi Shaiksaj,

I am able to ping the computer which is in the other network (connected through leased line).
And I am able to take its remote desktop (using mstsc command).

Eventhough we can not make clusting ?

Expecting your reply.

Thanks in advance.

Regards,

Tajudeen.
0
 
LVL 1

Author Comment

by:tajudeen_1
ID: 39710645
Dear Experts,

To start with, I wanted to try the Database mirroring for a database.   It is working fine within the same server (different instances).  

But it is giving error message when I do it with two different server.

Please find the error mesage below.

TITLE: Database Properties
------------------------------

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'costDb'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server network address "TCP://SQLJBL.compo.net:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Also please find the attached error print-screen.

Expecting your quick reply.

Thanks in advance.

Regards,

Tajudeen
0
 
LVL 1

Author Comment

by:tajudeen_1
ID: 39719595
My database MIRRORING problem has been solved after adding sql server service account into sql server login in all the instances of sql server.

But I am still waiting for the solutions for my ORIGINAL QUESTION.

Experts, pls advice.

Thanks,

Regards,

Tajdueen.
0
 
LVL 16

Expert Comment

by:Shaik M. Sajid
ID: 39719823
Greetings,

see the Overview of AlwaysOn Availability Groups (SQL Server)... the latest concept in SQL server...

the technical term in SQl2012 is " AlwaysOn Availability Groups (SQL Server) "

http://technet.microsoft.com/en-us/library/ff877884.aspx

http://technet.microsoft.com/en-us/library/ff877884.aspx

http://technet.microsoft.com/en-us/library/ff878487.aspx

but in the earlier version for (Synchronous Database between 2 storages)... which means both servers are active active... that must have a Gigabit connectivity link between both servers sites upto 5 milli seconds latancy...  thats what mostly environments uses these type of scenarios in the Lan system... or till where there network can fullfill the above pre requisites ( 1 Gb netword connectivity, upto 5 milli Second latancy)  which will do load balancing as well...

here data loss chances are approximately nothing but highly expensive..

related to asynch technology,

asynch technology that can be performed at storage levels... where the database replicated to the destination storage with any kind of bandwidth, any destination, ...

here the last updated snapshot can be restored...

that means there are Dataloss chancess but a for a small time ...


any how the latest technology in SQL2012 .. is the best proven for small size and medium sized organizations...

all the best

regards

Sajid
0
 
LVL 1

Author Comment

by:tajudeen_1
ID: 39726279
Hi Sajid,

Thanks for your reply.  I will go through it and come back to you.

Thanks once again.

Regards,

Tajudeen.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now