Hi All, Currently, I got a problem in backup process in log shipping. The backup process keeps processing. I have done a manual backup, and it works perfectly. In this case, it's just a matter of the generated job (LS_Backup) in log shipping is stuck. I did check the query running in the database and I found no backup process running. Another analysis, I tried to create a couple new blank databases and new Log shipping which refers to the new databases created. Unfortunately, the Log shipping (backup process) doesn't work as well. Any help would be very appreciated. Thanks in advance, Hery
You state you're running the RTM version of 2008. There was a bug with regards to running out of disk space that meant a backup would never complete and could leave a hanging SPID which would prevent the database from being backed up again until such time as you restarted SQL. I would recommend applying SP3 (the most recent version) or at the very least RTM CU7 which fixed that bug.