Backups - Basic Qs

[jordanwilson]

Hi;

I've researched elsewhere, however haven't found clear answers to the below.

I refer generally to SQL Server 2008 R2.

Short, simple answers preferred if possible.

More to follow, soon.

Thanks in advance.


- What is the benefit(s) of striping, and why - performance?
- Where does the backup media set header 'live' - is it present on all of the backup media in the set?
- What does the *name* of the command, 'init' mean - pertaining to instant file initialisation?
- How does the 'compression' command enable faster backups and restores?


J

[jordanwilson]

*Relocated to SS 2008 forum.

[Steve R Jones]

Continued here:
http://forums.databasejournal.com/sh...807#post132807