O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required