The
folder structure might be beneath an existing, company-wide FTP structure.
nNote SFTP is based on SSH for security, and FTPS is based on SSL certificates. The FTP server with IIS 6
doesn??™t support either protocol. If you??™re limited to IIS 6??™s FTP service, you need to use a third-party product
to encrypt a data transfer directly over FTP. (You can encrypt or secure a data transfer indirectly, but that
would add another chapter to this book.) Later versions of IIS should support FTPS, but not necessarily SFTP.
CHAPTER 6 n MAINTAINING A WARM STANDBY SERVER VIA LOG SHIPPING 153
Figure 6-5. As you can see, FTP is distinct from the actual Web server; you can run
FTP and not run IIS.
Figure 6-6. An FTP Virtual Directory almost always points to a local directory.
CHAPTER 6 n MAINTAINING A WARM STANDBY SERVER VIA LOG SHIPPING 154
2. Create a log backup job on the primary server: Simply create a log backup scheme
that writes to the shared location. If the shared location is hosted on the primary
server, simply write to that directory. If it exists on another server (which would
probably be the case for FTP, SFTP, or FTPS), create a second step to the SQL Agent
job that copies the current log backup to the appropriate server.
Pages:
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307