Viewing 15 posts - 1 through 15 (of 16 total)
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...
January 15, 2014 at 9:29 am
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.
January 14, 2014 at 9:01 am
I sent you a pm with my phone number. Feel free to call me to discuss your issue.
January 13, 2014 at 2:04 pm
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.
January 13, 2014 at 1:20 pm
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.
January 13, 2014 at 1:13 pm
Phil Coons (7/26/2012)
July 26, 2012 at 12:44 pm
Thanks, everyone. I got it working fine now. 🙂
April 24, 2012 at 5:34 pm
Well, it does seem to be a 64-bit issue after all. I checked MSDN for this, and found this link
When I run the dtexec, I get the...
March 9, 2012 at 12:14 pm
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.
January 22, 2008 at 6:56 am
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...
July 14, 2005 at 7:12 am
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...
April 27, 2005 at 5:41 am
The script in this example needs more documentation to fully understand it. Like, what is the sp sp_MSforeachdb?
April 26, 2005 at 8:53 am
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...
April 17, 2005 at 6:09 pm
OOPS! My typo mistake. Thank you for catching that for me. I will correct the restore script and try again.
April 15, 2005 at 12:40 pm
If you still are looking for a telecommuting SQL DBA, please email me at firstname.lastname@example.org. I have many years expereince as a SQL Server DBA and telecommuting.
March 1, 2004 at 4:29 am