MS SQL logshipping
Posted on 2011-02-14
We are going to setup a logshipping between our primary SQL server and DR site. let's say this is about database1 . that's the only database that needs log shipping.
1- We wanted to use same SQL server installation in DR site to run more databases (like database 2 ,3 ) for general purposes with other softwares . would that be possible ?
2- Once settiing up logshipping , I know that the process needs an extra SQL server to watch and monitor logshipping process. can that database server be used for other SQL instances ? (like run some databases as well) or it needs to be dedicated.