Logshipping Monitor does not work correctly

Hi all,
1st, I must say that I use the German Version of SQL Server. So I am
not sure if I translate the SQL features correctly to English.
I spent some time today setting up Log Shipping between 2 SQL Servers.
I used a Whitepaper I found at the microsoft.com Website.
Log Shipping seems to work fine. When I change Data on Server 1 I can
see the changes on Server 2 after the Logs are applied.
But I have one thing that doesnt work. And its the Logshipping
Monitor in the Enterprise Manager. When i open the Log shipping Pair
Properties and look at "last file copied" and "last file loaded" it
just shows first_file_000*.trn.
After 30 Minutes the Logshipping Monitor turns red and says that there
is an Error. But there isnt (not in the Shipping itself, I am sure
because it works!).
I dont know whats wrong here. The SQL Server runs as Local System on
both Sites. The SQL Agent uses a Domain Account which has SA rights on
the SQL Servers, Admin Rights on the Machines and Read / Write
privileges on the Fileshares where the Transaction Logs are copied.
I hope somebody can help here.
Thank you very much in advance,
Rene
On Tue, 22 Nov 2005 20:08:56 +0100, Rene Buedinger
<rbuedinger@.wz.xagxx> wrote:
Hi all,
OK I got it! My SQL Server Services where running as LocalSystem.
Because the Monitoring was running on the Primary Server, the
Secondary Server could not alter the Table log_shipping_secondaries.
After I started the SQL Server with a Domain Account which has the
necessary Rights on the Primary Server the log_shipping_secondaries
Table was altered and the Error went away.
Maybe this helps some others when they get the same Error.
Greetings,
Ren

Login Time and Last Batch not displayed correctly

I recently installed SQL Server 2005 CTP. Now in 2000 Enterprise Manager,
under Current Activity, Process Info, the Login Time and Last Batch columns
are not displayed correctly.
The time is displayed but the date is shown as a square to the left of the
time. This is the same for all SQL Servers registered.
Is there any way to display the date correctly?
Many Thanks
I think that's just one of the bugs, still in the CTP. It's not the
finished product yet, and it's not the only thing not working
correctly.
M
|||The CTP looks to be working ok but its affected my SQL 2000 Enterprise
Manager. I thought it was possible to run them both together.
Thanks
|||I reinstalled SQL Server 2000 and everything works correctly.
Many Thanks
|||Hi
It is, but the warning applies that since it is in beta, it is not
guaranteed not to affect other products.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"si" <si@.discussions.microsoft.com> wrote in message
news:EF2F2DA2-1BEA-4E62-A512-F244C9E25FBC@.microsoft.com...
> The CTP looks to be working ok but its affected my SQL 2000 Enterprise
> Manager. I thought it was possible to run them both together.
> Thanks
|||Hi
Re-registering the SQL DMO component would have done the trick too, but
since you did not post the question in the SQL Server 2005 Beta/CTP
newsgroup, you would have not had the benefit of an answer that would have
saved you a lot of work. This question came up a lot over there and has been
answered as many times.
http://communities.microsoft.com/new...r2005&slcid=us
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"si" <si@.discussions.microsoft.com> wrote in message
news:EE75CCCD-8384-49C3-8455-406B39B85813@.microsoft.com...
>I reinstalled SQL Server 2000 and everything works correctly.
> Many Thanks