Log-Shipping Architecture
Whether you??™re configuring a log-shipping plan manually or using an automated technique
via SQL Server, the basic architecture of the process is the same. As you??™ll soon see,
the log-shipping architecture is far more flexible than many realize. It will also become
CHAPTER 6 n MAINTAINING A WARM STANDBY SERVER VIA LOG SHIPPING 148
apparent that log shipping is an optimistic mitigation technique. Although it protects
data well, it doesn??™t help you recover from a disaster scenario without the application of
a little elbow grease.
Basic Architecture
The initial configuration of a log-shipping scenario is actually simple. Designate one
server as the primary and another as the standby. Copy a full backup of the database
from the primary server to the standby server and restore that database without recovering
it. (You remember the default RESTORE clause is WITH RECOVERY, correct? Be sure to
specify that you don??™t want that recovery.) Create a location on the network (a file
share or FTP site, for example) that??™s accessible by both the primary and standby
servers.
Pages:
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301