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

What Is a File/Filegroup Backup?

If you have limited time in which to perform a database backup and you cannot perform the backup using a full database backup, differential backup, or transaction log backup, SQL Server 2000 offers the option of performing a File/Filegroup backup. Files or filegroups can be backed up individually or together. Restoring a complete database from a File/Filegroup backup is a little trickier than a regular SQL Server backup/restore. Tables or indexes that span multiple filegroups need to have the files and filegroups with spanning objects backed up together. Fortunately, if you attempt to back up an object with spanning file/filegroups, SQL Server tells you that the missing file/filegroups must also be backed up. ...

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