SQL Server 2000 Backups—Simplified with Recovery Models (But Few Changes Under the Covers)
For those of you who have used previous versions of SQL Server and are curious about how your current backup and restore plans will change with SQL Server 2000, you will be happy to hear that you might not have to change any of your current backup and restore plans! SQL Server 2000 database restore still consists of database backups associated with transaction log backups. But the new recovery models introduced in SQL Server 2000 makes it easier for non-DBAs to successfully restore databases and for DBAs to understand exactly how their databases are protected against data loss. SQL Server 2000 still provides functionality and capabilities introduced in ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
