Solved

SQL server 2005 - database mirroring AND transaction log shipping on the same DB?

Posted on 2007-03-20
3
1,738 Views
Last Modified: 2012-05-05
I have a database setup with mirroring (high protection mode, no witness server).  I would like to setup transaction log shipping to a remote SQL server for the purpose of off-site backup.

Is it even possible to utilize transaction log shipping in a mirrored environment?  What happens if the principle server does down and I make the mirror server the principle server?

Also - with transaction log shipping, do I have to worry about identity columns like I'd have to with replication?

Thanks,
-- Jim
0
Comment
Question by:jimstjohn
[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
  • 2
3 Comments
 
LVL 20

Expert Comment

by:Sirees
ID: 18755594
From BOL:

"Typically, when combining log shipping and database mirroring, the mirroring session is established before log shipping, although this is not required. Then the current principal database is configured as the log shipping primary (the principal/primary database), along with one or more remote secondary databases. Also, the mirror database must be configured as a log shipping primary (the mirror/primary database). The log shipping secondary databases should be on different server instances than either the principal/primary server or mirror/primary server. "




0
 
LVL 20

Accepted Solution

by:
Sirees earned 500 total points
ID: 18755597
0
 
LVL 1

Author Comment

by:jimstjohn
ID: 18758464
Sirees:

Thanks for the help.  You didn't mention anything about identity columns in this scenario -- do I have to worry about them?
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

710 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