Out of interest sake, how do you go about verifying your backups?

I typically restore a backup and do a DBCC CHECKDB. My problem...

Cool thanks!

Does the account you are using on the Subscriber have access to the repldata folder?

Sorry for late reply ...

This works perfectly, thanks again.

Thanks!

There is a null value for the last period though ... will post back once I've understood what you've done:hehe:

Have you checked for any conflicts?

jim (3/30/2009)

---

No changes *should* be being made at the subscriber, but I can't take away the password from everyone. The hope was that if anyone did go rogue and started...

Do you need to get the IP via SQL?

I found this on the net:

EXEC Master.dbo.xp_cmdshell 'ipconfig'

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62872

Thanks for the links, it looks like a good supplement to my usual checks.

To clarify my original post; by steps I mean any sanity checks that can be done to...

No experience with Web Synch...

but do you maybe have the agent scheduled to run at certain intervals? In that case it will show as synchronising at the scheduled time only.

What...

I'm not sure I understand the objective, are you trying to save time in restoring a DB?

Replication will ensure that the data from Server 1 is replicated to Server 2...

Thanks!

It appears the agent does not need to be running on the Subscriber side.

Thanks for the feedback.

Re-Initialising worked, the conflicts did not return after they were removed.

I would guess that the user who created the DB would have the permission to do this ...

Perhaps you can add the login for that specific DB to db_Owner role?