If You need to create more then one SQL Server Standby database, it can be done easily with following window:
Just add standby databases (servers) to the marked window.
This is tested on SQL Server 2008 R2. You do not need to break current log shipping, just add new Standby server. Of course, You should follow all other requirements regarding network share access etc.
From my experience it is MUCH MORE EASIER set up log shipping when account under which SQL Server and SQL Server Agent run is named account instead of system account.
 |
| Multiple Standby databases |
This is tested on SQL Server 2008 R2. You do not need to break current log shipping, just add new Standby server. Of course, You should follow all other requirements regarding network share access etc.
From my experience it is MUCH MORE EASIER set up log shipping when account under which SQL Server and SQL Server Agent run is named account instead of system account.
