reggie burns-317942,

Here is a script I have that will generate the commands for creating backups of your databases that are participating in log shipping and are out of sync with...

Hi reggie burns-317942,

Based on your error message I would guess that the path to the backup is empty. You should try to do a print statement on each of the...

Hi reggie burns-317942,

I'm not sure what your looking for. I believe this article http://www.sqlservercentral.com/articles/Log+Shipping/75042/ describes the process of setting up log shipping including restoring the database to the secondary instance.

In...

dhodgeh,

If you could avoid blowing away the database and only change the objects within it then you wouldn't need to rebuild log shipping.

I suppose you could also create a job...

reggie burns-317942,

Wow 1500 DBs. That's impressive.

I don't have any experience with working across domains so maybe someone else out there can clarify this but I don't see that you should...

zdvsoftware,

Here is how you could go about having your script actually execute instead of just generating a script.

-- RECOVER ALL DATABASES

DECLARE @sql varchar(MAX)

SELECT @sql = COALESCE(@SQL...

Thanks zdvsoftware. This is a very efficient way to recover the databases. Since you've taken us down this road what do you think about added the script to disable the...

Thanks Steve. Awesome article. I'm adding this one to my briefcase.

Adam,

Very interesting idea for mitigating data loss.

Thanks

John Sargent-410636,

The report does not appear to be impacted by this. I'm a little weary of some of the "time since" columns that appear to repeat the same value but...

Jon,

Thanks!

Yuri55,

But it's not database size that determines the interval, it's the transaction log size.

Thanks

Yuri55,

Yes, some of my databases are on the smaller side but the solution is still sound for any size DBs.

We are backing up transaction logs and it is the...

Yuri55,

I am using clustering, 1 active, 1 passive. The purpose of log shipping for me is to have a secondary location that the data exists at in case the cluster...

bret.lowery,

Memory and CPU usage is much better than it was when I had all 130 DBs running from separate jobs. That's what I like about this solution, only 1 execution...