Hmmm a bit strange but also happened to me the first time i setup a log shipping with a copy and restore threshold of 15 minutes. In my case the...

Whats your range of too high???

whats your scheduled backup and restore threshold interval????

Log Shipping is now successfull The reason why it has many errors yesterday is that MSSQLSERVER is not using the domain account (My Bad) 😀 Anyways many thanks to Ratnesh...

I made a database test in server A then make a backup of it then restore it to server B in read-only mode then apply the log shipping but after...

What i did is that i restore the database using EM choosing the option in recovery completion state "leave database read-only and able to store additional transaction logs" then the...

The "Transaction Log Backup job for db maintenance plan" is now on error.

I am now getting this error message.

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC SQL Server Driver][SQL Server]Database...

Thanks!!!! I think i have an idea about the error i encountered Do you think the process i did is right?? the only problem is that i must first restore...

Thanks Ratnesh Kumar Dwivedi for giving time to answer my questions so here it is....

Assuming Production ServerName = A, Destination and log shipping monitor = B

1. i pick the northwind...

Hi this is the error message in the log shipping monitor. Transaction log backups are now seen in the secondary server folder its the log shipping restore (in the secondary...

I encountered the same problem months ago i think the problem is with the auto close being checked in your database property check each of your databases to see those...

YEah your right the destination folder is not updated...

I thought the duty of replication is to replicate or copy data from 1 publisher to subscriber/s?? Our reason of replicating databases is that my superior wnats a live backup...

that's a good script you have there gdmilner but in order to script all the users you must run the script in each of the databases and not to mention...

Yeah my scenario is also same as you i searched for many commands that will do the trick but end up making 1 😀

Ohhh 1 thing.... the script i gave...