Results 1 to 3 of 3

Thread: Backups - Basic Qs

  1. #1
    Join Date
    Nov 2014
    Posts
    5

    Backups - Basic Qs

    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

  2. #2
    Join Date
    Nov 2014
    Posts
    5
    *Relocated to SS 2008 forum.

  3. #3
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    78

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •