Repair of a suspect SQL DB

Found myself needing to repair a suspect SQL db. A really nice post here listed the following commands:

EXEC sp_resetstatus ‘yourDBname’;

ALTER DATABASE yourDBname SET EMERGENCY

DBCC checkdb(‘yourDBname’)

ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE yourDBname SET MULTI_USER

I tried them and it recovered my DB! Excellent post, thank you Manoj!

Advertisement

Online Storage and Backup Solutions

I quick list of notable online storage solutions as listed on http://www.onlinebackupreviews.com/Server-Online-Backup.html

http://www.backblaze.com – $50/year. offers unlimited storage, continuous backup with ability to go back in time up to 4 weeks. limits file size to 4 GB

http://mozy.com/ – $55/year. offers free no-hassle 2GB accounts (http://mozy.com/home/free), continuous backup with ability to go back in time up to 30 days, backs up open files (such as PSTs), ability to also schedule backups, in addition to the automatic/continuous backups

http://www.i365.com/

http://www.datadepositbox.com/

http://www.aplus.net/

http://www.icebackup.net/

Read-Only Hard drives – a very rare issue and a very useful post

I ran across a rather odd issue with an external USB drive that all of a sudden became read-only. After some digging on the net found this post with very useful info:

http://www.t3chworks.com/index.php?p=2_1

Thanks to the owner of T3chWorks!