Solved

SQL Server - Backup server

Posted on 2013-11-12
10
33 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
2007 SCCM 5 63
SCOM Reporting 2 50
Skype for Business Install Issue - Service won't start 2 346
SCOM 2012 R2 (UR 8) web console loads but alert pane is blank 3 211
This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  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…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

740 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