log shipping on sql2000 standard

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

log shipping on sql2000 standard

Author

Topic

netjam
Starting Member

37 Posts

Posted - 2008-04-10 : 21:19:46

I created log shipping procedure which transfer every 15 min log to a remote server and restore it.
Restore process requires exclusive access so I to have kill all connection prior.
Question: Is there any way it can be done with out removing all existing connection to db.

Because this db is used for reporting.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-10 : 21:25:56

Best way is to choose :disconnect users while restoring option but you can delay restoring by scheduling restore jobs. If you do,log shipping might fail.

netjam
Starting Member

37 Posts

Posted - 2008-04-10 : 21:41:40

But whole point is to keep users (reports) with up to 15min old data.
Is there other way to do it (not LS)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-10 : 22:20:23

Does replication work?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-10 : 22:39:22

I would do transactional replication if tables have primary key.

netjam
Starting Member

37 Posts

Posted - 2008-04-10 : 23:27:10

replication failing because of db structure

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-10 : 23:29:47

What do you mean ? Do tables have primary key? What is the error while setting up replication?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-10 : 23:30:00

quote:
Originally posted by netjam

replication failing because of db structure

Please elaborate. It's your best option for reporting.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

netjam
Starting Member

37 Posts

Posted - 2008-04-11 : 01:08:31

quote:
Originally posted by sodeep

What do you mean ? Do tables have primary key? What is the error while setting up replication?

one table has too many columns. Do not look at me I have not designed
this db. But this is the most important table and frequently updated.

netjam
Starting Member

37 Posts

Posted - 2008-04-11 : 01:09:43

all tables have primary key

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-11 : 09:56:32

Then what is the problem? Go ahead with Tran Replication. How far is remote server located? Do you have good network bandwidth(speed)?

netjam
Starting Member

37 Posts

Posted - 2008-04-11 : 19:04:02

quote:
Originally posted by sodeep

Then what is the problem? Go ahead with Tran Replication. How far is remote server located? Do you have good network bandwidth(speed)?

locations: europe,nth america,australia
I'll need central subscribers with many publishers
link: private vpn

But I was informed by prev dba that all attempts to replicate
failed because of this table(any clues).

I think I to have give a try. thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-11 : 19:08:41

what??? you are doing replication accross the globe.If you have multiple publishers and one subscriber ,you will have lock,conflict issue. Well, they have new features called peer-to-Peer replication
for this scenerio. I would first check the bandwidth(speed) before applying this

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-12 : 00:06:22

Peer to peer replication is on sql2k5 only, take look at merge replication in this case.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-12 : 00:30:24

My bad P2P Rep is new feature

netjam
Starting Member

37 Posts

Posted - 2008-04-12 : 00:39:12

quote:
Originally posted by sodeep

My bad P2P Rep is new feature

That is good to hear!

Because I am asking and asking management for a server upgrade.

Probably 2008.
Do you know if P2P replication is avalable for 2008 standard edition.
I know that child server can even fix corrupted records on parent (publisher server)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-12 : 00:44:45

>> Do you know if P2P replication is avalable for 2008 standard edition.

Have to wait for formal release to know.

netjam
Starting Member

37 Posts

Posted - 2008-04-12 : 00:48:27

quote:
Originally posted by sodeep

what??? you are doing replication accross the globe.If you have multiple publishers and one subscriber ,you will have lock,conflict issue. Well, they have new features called peer-to-Peer replication
for this scenerio. I would first check the bandwidth(speed) before applying this

Lock? I do not think so, at least on this stage. Each publisher
updates it's owne db on subscriber. Centralized reporting it's a bunch of views and unions.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-12 : 01:15:47

You don't need p2p replication from what you said.

netjam
Starting Member

37 Posts

Posted - 2008-04-12 : 01:20:40