CHAPTER 6 n MAINTAINING A WARM STANDBY SERVER VIA LOG SHIPPING 159
Figure 6-11. You can add a new secondary server from the primary log-shipping server.
Figure 6-12. Options when copying a database to a secondary server
CHAPTER 6 n MAINTAINING A WARM STANDBY SERVER VIA LOG SHIPPING 160
The first option is to generate a new full backup and restore it on the secondary
server. If you choose this option, you must specify the location of the data files and the
log files (as indicated by the arrow in Figure 6-12). You do this using the Restore Options
dialog box shown in Figure 6-13. The result of specifying the data and log-file directories
is the functional equivalent of restoring a database using the WITH MOVE clause.
Figure 6-13. Be sure you have enough disk space available for the secondary log-shipping
database.
The second option for restoring a backup is almost identical to the first option. It
allows you to use an existing backup in the network location of your choice. One warning
if you use this option: be sure you have an uninterrupted string of transaction log
backups corresponding to the backup file you choose to use.
Pages:
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315