The blog topic might seem controversial and doesn’t go well with definition of log shipping features. Read it again. The blog has an alternative way to set up something “similar” to log-shipping. If the database is in simple recovery model, then we can’t take transaction log backups and hence no log shipping possible.
SQL SERVER – Database going to Recovery Pending Automatically and Coming Back
I love connecting community via various channels. One of my clients explained an interesting issue to me. He explained that he has a production database which is going to Recovery Pending state by itself and without any user intervention, it’s coming back as well.
SQL SERVER – SysTools SQL Recovery Software – An Experiment to Recover Database Corruption
NOTE: This was my experiment with database corruption. If your database is corrupted, you should contact professionals who do this as their primary job. Always make sure that you do experiments on the copy of your database on your development server, rather than on production server. Let us learn about Recover Database Corruption.