logshipping in sql 2000

Question

logshipping in sql 2000

ravirayakulkarni

SSC Veteran

Points: 236
More actions
May 17, 2008 at 10:14 am

#190622

how simple i can illustrate the use of logshipping in sql 2000[/quote]
using one default instance and a second instance. how simple i can understand the concept of logshipping in sql 2000

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Clive Strong SSChampion Points: 11222 More actions · Answer 1

Quite simply, log shipping is the process of moving transaction logs from one instance to another and restoring them onto the 2nd instance.

The logs are backed up on the 1st instance, shipped (moved) to the 2nd instance and then restored. I've never actually used log shipping but I have worked on a custom log shipping system which used vb script.

ravirayakulkarni SSC Veteran Points: 236 More actions · Answer 2

that's ok

but while implimenting iam unable to understand

'in the add destination server, if i check the box

"allow database to assume primaryrole the destination server

name becomes inactive " my problem is if the check box is not checked

then how can the secondary server take the role of primary server when

primary server fails'

if you can answer this it would be fine

thankq very much

george sibbald SSC Guru Points: 104210 More actions · Answer 3

then you would just have to do it manually by bringing secondary database online

either

restore database dbname with recovery

or

restore any outstanding tran logs and use the with recovery clause for the final tran log rstore

and possible resynch any orphaned userids (sp_change_users_login)

then point the app at the new server (usually a DNS change)

---------------------------------------------------------------------

ravirayakulkarni SSC Veteran Points: 236 More actions · Answer 4

when creating the maintainance plan whether i have to

check the box which says

allow the database to assume the primary role

can u put some light on this

thanq

george sibbald SSC Guru Points: 104210 More actions · Answer 5

you do not HAVE to check this box for log shipping to work.

---------------------------------------------------------------------

ravirayakulkarni SSC Veteran Points: 236 More actions · Answer 6

if i dont do that then how can the

secondary server take over the job of primary server

george sibbald SSC Guru Points: 104210 More actions · Answer 7

ravirayakulkarni (7/16/2008)
if i dont do that then how can the
secondary server take over the job of primary server

see my earlier post on how to bring it online. If the original server comes back on linr just re-setup log shipping in the other direction.

---------------------------------------------------------------------

ravirayakulkarni SSC Veteran Points: 236 More actions · Answer 8

ok, understood.

i will not check the check box which says that allow database to assume

primary role right?

can u explain me steps once again

i will be thankful to you

george sibbald SSC Guru Points: 104210 More actions · Answer 9

unless you are planning to regularily fail over then it is not necessary to check the box.

to make secondary the live database:

bringing secondary database online

either

restore database dbname with recovery

or

restore any outstanding tran logs and use the with recovery clause for the final tran log restore

and possible resynch any orphaned userids (sp_change_users_login)

then point the app at the new server (usually a DNS change)

---------------------------------------------------------------------

george sibbald SSC Guru Points: 104210 More actions · Answer 10

also, read this article:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

---------------------------------------------------------------------