473,587 Members | 2,487 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS SQL 2005: DB Mirroring and Log Shipping

6 New Member
I am setting up a HA solution which incorporates both the DB Mirroring and Log Shipping with SQL Server 2005.

However I am running into a bit of a snag in configuring the mirror as the primary/inactive log shipped database.

From what I can tell one should be able to configure the mirror DB separately as a logged shipped database and when a mirror failover event happens the Log Shipping jobs should be able to come from whichever is the active DB.

According to all the documentation I have it is possible, however it is a bit fuzzy on the details. Is this a MS pipedream or Reality? Has anyone accomplished this?

Your input?
Apr 23 '07 #1
1 5790
epikto
6 New Member
I was able to figure it out.

Here is my solution. I welcome your comments.
Prerequistes: Mirroring Endpoints, 3/4 servers (primary/mirror/logship/Logship backup servers), SQL Server 2005

1. create a backup of the database to be mirrored logshipped
2. copy backup to both mirror server and log ship server
3. recover backup fully on mirror server
4. set up log shipping on the mirror server (initially disable backup job)
5. re-recover database in NORecovery mode
6. point mirror database at primary database
7. set up log shipping on the primary server (initially disable backup job)
8. re-recover database on primary database (Key! - I'm not sure why however)
9. point primary database to mirror database to initalize DB mirroring (also may setup a witness at this point)
10. setup log shipping on log ship server (initially disable copy and restore jobs)
11. ensure that all settings are working correctly and DB Mirroring is fully functional
12. Enable backup jobs and then copy and restore jobs for Log Shipping

What this accomplishes is a Mirrored database which also log ships from two locations (both the primary and the mirror db). Upon a mirror failover event the Mirror DB will continue logshipping

I am still testing this solution. Hopefull you can make some use of this information.
Apr 25 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
2808
by: Mulder | last post by:
Has anyone enabled log mirroring under DB2 v8 on AIX 4.3.3 or 5.? and if so are you archiving these mirrored logs to TSM? Is this possible? If so is there any sample code for the user exit and mirrored logging? Thanks
3
3590
by: Michael Henry | last post by:
Hi, I'm a DB2 newbie so please don't be too harsh :) I'd like to replicate a DB2 database to a remote server which will be used for disaster recovery. What I'd like to know is: what options are available to achieve this? The data doesn't have to be absolutely up-to-date. What we're thinking at the moment is a cron-job which runs...
4
1501
by: Glen Eustace | last post by:
I thought I had seen something that indicated that v8 was going to provide a means to mirror databases without needing all the triggers etc. I downloaded beta 3 but couldn't see anything that would do this. My goal is to mirror a database from one server to another, hopefully from the logs so that there is nothing added to the database. The...
5
2158
by: Ryan | last post by:
I'm devlving into 2005 and specifically mirroring. Having read the following article ( http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx ), is mirroring a sensible option as it indicates that it should not be used in a production environment, yet the SQL2005 seminars I've been to indicate that this is a worthy option. ...
4
4912
by: R.A.M. | last post by:
Hello, I am learning SQL Server 2005 Express. I need to test replication but when I run New Subscription Wizard I got error: "There are no publications to which you can subscribe, either because this server has no publications or because you do not have sufficient privileges to access the publications." I see no option for publications. Does...
0
4390
by: serge | last post by:
I have 2 SQL Enterprise Editions running SP2 and same collation. When i try to start database mirroring I get the following error message: "The remote copy of database "ABC" has not been rolled forward to a point in time that is emcompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)" Both SQL Server...
0
3038
by: umeshpotdar | last post by:
i am doing mirroring on the data base i have done every step but i got problem below "Database Mirroring Transport is disabled in the endpoint configuration." this problem occured when i cilck on the "start mirroring" button can anybody know about mirroring
3
3253
by: Lee T. Hawkins | last post by:
I am having a number of problems over the last two full days trying to get an ASP.NET 2.0 application to connect to a SQL Server 2005 database... First off, I built this application w/ Visual Studio 2005 SP1 and had it working perfectly on my Windows XP machine on SQL Server 2005 Express. I decided to publish this application to a test...
0
1203
by: pratimapaudel | last post by:
I need to do the mirroring of my company's production DataBase. I am not planning to setup the witness server. I am planning to do mirroring between two servers only. Can anyone tell me how long it will take? How many hours it will take to setup everything? I have to give the approximate time to complete thhis to my department manager. I...
0
7920
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7849
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8215
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8347
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6626
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5718
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3844
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2358
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.