Solved

SQL Server - Backup server

Posted on 2013-11-12
10
30 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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
 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

832 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