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 2005 Forums
 High Availability (2005)
 How to enable monitor server instance.

Author  Topic 

sunder.bugatha
Yak Posting Veteran

66 Posts

Posted - 2008-03-21 : 01:26:38
Hi,

I set up logshipping between two servers. One was a developer edition and other was Enterprise evaluation edition. Log shipping setup was successful.

Back up job was created on the primary server and copy , restore jobs on Secondary server.

But copy job is failing on the secondary server with the below error :

Message
2008-03-21 10:46:22.62 *** Error: There are no more files.
(mscorlib) ***


This is the first issue.

And the Second issue is that when i try to create a monitor server instance then i see that it is not enabled on the Primary server.

The monitor server is of SQL Express edition.

This whole logshipping i am creating on my own PC by installing different instances.

Please help.

Regards,
Sunder

Hema Sunder

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-21 : 14:20:56
Make sure the secondary server has access to shared folders in primary server so that it can copy and restore.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-21 : 17:45:49
Is it on secondary instance? You choose minitoring server when configure log shipping.
Go to Top of Page
   

- Advertisement -