SQL SERVER 2008的Log Shipping如何进行主备库切换,如果主机当了,如何将备库切换成主库?
请教各位大虾!
------解决方案--------------------------------------------------------
参考:
http://ecmcug.itpub.net/redirect.php?fid=40&tid=1420895&goto=nextoldset
------解决方案--------------------------------------------------------
sorry,命令打錯,
- SQL code
restore database [數據庫名] from disk='[最後可用的日誌備份]' with recovery