Yes.

In SQL Server 2005 the process of implementing Log Shipping is embedded with the Workgroup, Standard and Enterprise editions of SQL Server.

Tried to open the SQLAGENT log file, but throws an error as being used by another process..

Thanks for your suggestion.

I have already done the same , the rest of the instances are working fine with same accounts and processes done.

also followed the article :

Hi All,

Thanks for your responses.

We update the passwords manually using scripts..

Changed password and tried again, but failed with the below error like:

The SQL Server Agent (XXX) serice failed to start...

SQL Server Services are running fine with the same account.

Hi Rohit,

Tested all the things with accounts and permissions. Still no use...

Its throwing the same error.

- Win.

Any suggestions please..........

Hi,

It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....

Please find the below error log.

2010-06-25 02:52:33...

Gianluca Sartori,

Good One.... I will try to work with this script and post you.... Reply will be delayed, as I have to get confirmation and required permissions to do so....

Excellent Lowell

You helped me alot.... Thanks a ton for your quick and prompt response.

Appreciate your fast help ..!!!

Can this be for every instance in every box for multiple instances as well.?

Can you please explain me in detail. As am not that much into...

Done.

Thanks Lynn.

Good Points Amin.

Thanks Lynn for the fast response.

-----------------------------------------------------------------------------------

change the NOINIT to INIT in your backup database command. This will allow SQL Server to overwrite the previous backup.

------------------------------------------------------------------------------------

BACKUP DATABASE [DatabasetoBackup] TO DISK =...

Yes,

1. As said above, check TCP/IP and Namedpipes enabled on both the servers. Check service accounts as well for SQL Services.

2. Drop Replication.

3. Follow rules to replicate the DB from...