Figure 6-7. The check box lets you enable the log-shipping configuration dialogs.
From that point on, configuring log shipping in SQL Server 2000 is almost identical
to configuring it in SQL Server 2005, so I??™ll focus on SQL Server 2005 in the rest of this
chapter.
Log Shipping in SQL Server 2005
If you aren??™t keen on manually configuring log shipping and don??™t happen to have the
Enterprise Edition of SQL Server 2000, SQL Server 2005 is the answer to your logshipping
dreams. (OK, maybe I??™m the only one who has that dream. Have I mentioned
that I??™m a geek?)
The main change from SQL Server 2000 to SQL Server 2005 with respect to log
shipping is that everything in SQL Server 2005 is carried out via stored procedures
rather than called by some black-box .exe. That makes me very happy. In SQL Server
2005, you implement log shipping with actual stored procedures that you can look at
and see exactly what they??™re doing. This goes for all of the activity on the primary
server, the secondary servers, and, if you??™re using one, the monitoring server.
Enabling log shipping begins at the primary server.
Pages:
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310