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 |
|
SQLCode
Posting Yak Master
143 Posts |
 Posted - 2007-10-25 : 12:01:05
|
| My log shipping is not producing any errors on the destination but it also not updating the database.We use sql 2000 on win 2003 servers.Any ideas?All I know is that the source server was rebooted for regular maitenance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 12:13:10
|
| Is it copying the tlog backup files to the secondary server?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2007-10-25 : 13:11:23
|
| Thanks Tara for the reply.Good point. How can I find out? I see maintenance jobs but do not know the directory location. I tried finding trn files and did not find many. I found .tuf files though. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 13:12:52
|
| Look at the maintenance plan on the primary server to determine the location of the backup files on the secondary server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2007-10-25 : 15:20:58
|
| Looks like they are not being copied. Lets see how I can find out why they are not copied. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-25 : 22:47:51
|
| Did you start sql agent with domain account on those servers? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 22:51:35
|
| The most common cause of this issue is that the share was not setup correctly.The share must exist on the primary server. The share (or share and path in the maintenance plan) must point to the directory where the tlog backups. The secondary server must be able to get to it via the service account logon. The secondary server pulls the files and not the other way around.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2007-10-31 : 13:29:00
|
| Thanks Tara, apparently the domain account that was copying files over to secondary server had changed. So the copy over was failing.I did not see any red circles on destination because there the restore job did not file any files to restore, but that is not a failure.One of our network admins had to leave abruptly and we had to either change the account or password.Will let you know if we have more puzzles to solve. |
|
|
|
|
|
|
Log shipping not updating