Backing up
full-text catalogs was the only backup need for one of my clients, yet SQL Server 2000 was
the only platform they had. To perform their backup, they had to shut down the
Microsoft Search service, back up all of the external index files, and restart the service.
Another thing to consider is that you??™ll need to rely on external systems to back up
the full-text index files at an operating-system level (often by using a backup agent
capable of backing up open files). The full-text indexes are tightly coupled with the
data they??™re built from. If there is change to the database, simply restoring an old copy
of the index files won??™t work??”you??™ll have to rebuild the indexes completely.
Initial and Periodic Testing
The most important piece of any backup and recovery plan is testing. Of course, after
you??™ve designed the plan, you should thoroughly test both the impact of the backup
process and the success of the restore process. That means that restoring a single backup
is not sufficient. You should test it in as real-world a scenario as possible. If backups run
during periods of production use, you should test them.
Pages:
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278