Thank you Jon.Morisi,

It is great to query the table Backupset and I found that there is an extra log backup between 5:00 and 5:15. The log shipping ships the log...

Thanks Jon.Morisi,

That's my question. I had 03/01/2016, 5:00 am restored successfully and 5:15 am with a "too recent" error! There is no backup and .trn file between these two logs,...

Thank you Jon.Morisi and Perry Whittle for the valuable replies.

I got an error when doing the log restoring in log shipping and want to know why.

When I restored the...

Hi,

Even I restored the log files and resume the LS, there is an issue when I restore the T-log. As I need to restore many log files and after...

Hi Beatrix Kiddo,

Yes I did check that check box.

Thanks,

Hi Perry Whittle,

I didn't want to double post the topic. As I found the other area has a more meaningful description about my topic, I was trying to transfer this...

Hi Jon.Morisi,

After restoring a full backup and multiple log backups, the log shipping jobs resume to run.

Thank you so much for the helps.

Best regards,

lw

Hi,

After I manually restored the full backup, I enabled the log restore in the secondary server to start the log restoring (every 15 minutes as designed). I got error every...

Hi Jon.Morisi,

My production DB is over 100 GB and the DR server is in different state. So, if I make a full backup and copy the (.bak file) over to...

Hi Jon.Morisi,

I restored the full backup and from the table [log_shipping_monitor_secondary] find the last restored file is: '\\DRserver\...folders\UserInfo_1_20160222091505.trn'. I don't know why it restored to the date/time of 02/22/2016 at...

Hi Gail,

I tried it as you said. But after I detached the old database and was trying to restore to it, I got the "database is in use" error when...

Hi Gail,

Yes, the old database was detached and data/log files were renamed. As I know, detaching a database actually removes the entry for that database. What I was doing again...

Hi Gail,

Yes, the database Prod1_Content was the corrupted one. I detached it and renamed the .mdf and .ldf files.

So, let me clarify my question.

When created a new database, can...

Hi Eddie and Gail,

Thank you for the reply and suggestion.

I’ve detached the database and created a new database. As you suggested, I’m trying to restore the database with a backup...