Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server - Backup server

Posted on 2013-11-12
10
Medium Priority
?
45 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 17

Accepted Solution

by:
Sajid Shaik M earned 1500 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 17

Assisted Solution

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

it's only on premises... by sharing same storage...
0
 
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 17

Expert Comment

by:Sajid Shaik M
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are trying to access the server, have you ever encountered "The terminal server has exceeded the maximum number of allowed connection" error?  or "The user is attempting to log on to a Terminal Server in Remote Administration mode, but the …
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…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

564 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