Leading companies are already achieving incredible numbers. SQL Server 2000 offers a number of backup options that can run while your database is still online. One option is a differential backup, which copies only the pages that have been modified since the last backup operation. Because they can be conducted rapidly and with minimal server impact, differential backups can run more often, decreasing the risk of data loss. With log shipping, SQL Server 2000 makes it possible to automatically synchronize physically-separated databases by sending transaction logs from one server to another.
Log shipping improves scalability by offloading query processing to read-only destination servers.
In this configuration, when one node fails, the SQL Server and operating system resources can fail over to any other surviving node. The emergence of business-process automation applications marks an important new trend. These applications deliver greater efficiency and productivity, freeing workers from many of the mundane tasks of running a business. Web Access to Data. One unavoidable fact of life for all companies is that all commerce is fast becoming e-commerce.