I have created two sql scripts: First one will create Log Shipping for all databases that are not already setup for Log Shipping on the primary server. My second script...

I would copy the code from the restore job, and run it in a command window. That way, you will see what the error is.

I sent you a pm with my phone number. Feel free to call me to discuss your issue.

Let me know if it still does not work. I have successfully setup hundreds of Log Shipping databases, with SQL Server 2008 R2 and SQL Server 2012.

Has your Log Shipping every worked for this database? It is possible that is is out of sync. You may nee to reload a new backup and try again.

Phil Coons (7/26/2012)

---

what did you do to get this working? I am having the same problem and I have tried all the above suggestions, with no luck. ...

Thanks, everyone. I got it working fine now. 🙂

Well, it does seem to be a 64-bit issue after all. I checked MSDN for this, and found this link

http://msdn.microsoft.com/en-us/library/ms141766.aspx

When I run the dtexec, I get the...

Thank you both! I just implemented this script and it works perfect!

Thank you SQLServerCentral.com for this forum to allow users to help each other.

Here is MY running out of space scenerio:

Over the 4th of July holiday weekend, my SAN ran out of space for backups. Becasue of this, the transaction logs began to...

Yes, I modified the script to use a temp table, but it worked fine. Thank you everyone for your help! I now showed my boss that we have 690 GB...

The script in this example needs more documentation to fully understand it. Like, what is the sp sp_MSforeachdb?

Thank you. I have already learned about SMTP Mail, and am aware of using it for DTS packages. What I reaaly need is a solution for Alerts, which are bound...

OOPS! My typo mistake. Thank you for catching that for me. I will correct the restore script and try again.

If you still are looking for a telecommuting SQL DBA, please email me at csdunaway@yaoo.com. I have many years expereince as a SQL Server DBA and telecommuting.

 

Clif