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.
| Author |
Topic |
|
Monika
Starting Member
5 Posts |
 Posted - 2003-10-01 : 16:47:40
|
Hello,I'm having some trouble with simple log shipping. I'm using SQL Server 2000/SP3. I think I have everything setup correctly, but when I test out the job to back up the T-Log and restore it to the Standby server, the job itself doesn't stop running until I cancel it. I set the parameters in the job to run every 10 mins for 2 hours. The T-Log gets applied but the job keeps on executing way past 2 hours  . I checked under process info and it seems to be awaiting command. Has anyone else come across this problem and maybe have some suggestions for me.Thanks so much for your help !!!Monika |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-01 : 16:54:10
|
| What do you mean every 10 minutes for 2 hours? What does the two hours part mean?Tara |
 |
|
|
Monika
Starting Member
5 Posts |
Posted - 2003-10-01 : 17:02:59
|
The duration of the job is 2 hours.exec sp_ShipLog@DBName = 'HBES',@StandbyServer = 'TestSrv',@BackupLocationPath = '\\TestSrv\TestSrv C\Restore',@UndoFile = 'C:\hbes_undo.dat',@MinuteInterval = '10',@HourDuration = '2'quote:
Originally posted by tduggan
What do you mean every 10 minutes for 2 hours? What does the two hours part mean?Tara
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-01 : 17:06:30
|
| Why would you want it to run for 2 hours? Just set it to run every 10 minutes. It'll complete when it completes. What is sp_ShipLog? I didn't find this stored procedure on any of our servers here.Tara |
|
|
|
Monika
Starting Member
5 Posts |
Posted - 2003-10-01 : 17:32:51
|
@HourDuration is a required parameter for sp_ShipLog and I only want log shipping to occur during regular business hours (which is sufficient for my company). The 2 hour duration in this case is just for testing purposes.sp_ShipLog/sp_ApplyStandbyLog are a set of stored procedures to enable log shipping in SQL Server 2000 Standard Edition. They can be found in the SQL Server 2000 Resource Kit. quote:
Originally posted by tduggan
Why would you want it to run for 2 hours? Just set it to run every 10 minutes. It'll complete when it completes. What is sp_ShipLog? I didn't find this stored procedure on any of our servers here.Tara
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-01 : 17:46:58
|
| Oh I see. I've only used log shipping for enterprise edition. It sounds like duration is not what you want to set. Take a look at the job to see what it has for the Daily Frequency. It should have a start and end time. That's what you would want to configure. You should also start up log shipping about half an hour to an hour before people arrive at work so that log shipping can catch up.Tara |
|
|
|
Monika
Starting Member
5 Posts |
Posted - 2003-10-03 : 10:57:17
|
| Thanks Tara. I will look into configuring the start and end time for the job. |
|
|
|
|
|
|
simple log shipping