SQL Databases

Databases need to be backed up on B4. (backfour)

Instead of datalists, schedule files are in barlists:
F:\omni3.5\Config\Barlists\*SQL

You can't edit the schedule file with Unix, you have to use a PC, or you will own it, not "root".

sql 7 has incr, full, trans (trans is transaction log)
sql 6.X has full or trans only.

It takes 9 lines for ONE database:

master:0
model:0
msdb:0
Northwind:
plus user files...

        --------------------------------------------------------------
           1. master                      8 MB             3 min (       238 Mb/h)
           2. model                       1 MB             1 min (      3135 Mb/h)
           3. msdb                        9 MB             1 min (      4275 Mb/h)
           4. Borman_Expressway        1028 MB            12 min (      5400 Mb/h)
           5. borman2SQL                  4 MB             1 min (      5864 Mb/h)
           6. Northwind                   4 MB             1 min (      5512 Mb/h)
           7. test9                       3 MB             1 min (      3803 Mb/h)
           8. pubs                        2 MB             1 min (      4935 Mb/h)
           9. adp2SQL                     2 MB             1 min (      3600 Mb/h)

              Sum:                     1056 MB            15 min (      4528 Mb/h)
        --------------------------------------------------------------

There is an account (administrator for database) called "sa". You need the password.

Using the local root password, it blows up.

Sample schedule file:

  BARLIST "civl3125cpc1-squeel"
  OWNER root sys back.ecn.purdue.edu
  RECONNECT
  DYNAMIC 1 5
  DEVICE "dlt4" 
  {
  	-concurrency 1
  	-sync
  	-buf 1
  } 
  
  CLIENT "MSSQL70" civl3125cpc1.ecn.purdue.edu
  {
  	-exec sql_bar.exe
  	-args {
  		"-dev_n:1"
  		"backupall"
  		"-n:1"
  	}
  	-public
  }  -protect weeks 52

Note: For now, use "notepad" to edit this file, and it doesn't end in ".txt".

[Normal] From: BSM@backfour.ecn.purdue.edu "civl3125cpc1-squeel"  Time: 12/19/00 08:41:59
        OB2BAR application on "civl3125cpc1.ecn.purdue.edu" successfully started.

[Normal] From: OB2BAR@civl3125cpc1.ecn.purdue.edu "MSSQL70"  Time: 12/19/00 8:45:01 AM

        Hewlett-Packard OmniBack II Backup and Restore Agent for Microsoft SQL Server 7

        connected to SQL Server version 7.0 on machine CIVL3125CPC1

        Microsoft SQL Server  7.00 - 7.00.623 (Intel X86) 
        Nov 27 1998 22:20:07 
        Copyright (c) 1988-1998 Microsoft Corporation
        Desktop Edition on Windows NT 4.0 (Build 1381: Service Pack 6)



[Normal] From: OB2BAR@civl3125cpc1.ecn.purdue.edu "MSSQL70"  Time: 12/19/00 8:45:08 AM
        Character set: Character Set = 1, iso_1    ISO 8859-1 (Latin-1) - Western European 8-bit character set.
        Sort order   : Sort Order = 52, nocase_iso    Case-insensitive dictionary sort order for use with several We 

[Normal] From: OB2BAR@civl3125cpc1.ecn.purdue.edu "MSSQL70"  Time: 12/19/00 8:45:08 AM
        Direct mode for local devices is activated.

[Normal] From: OB2BAR@civl3125cpc1.ecn.purdue.edu "MSSQL70"  Time: 12/19/00 8:45:08 AM
        Backup of complete SQL Server 7. Getting database names.
[Normal] From: OB2BAR@civl3125cpc1.ecn.purdue.edu "MSSQL70"  Time: 12/19/00 8:45:08 AM

        Pre-backup database information:


        Database name ........: master
        Requested backup type.: full
        Approx. backup size ..: 8846 kB
        Backup group .........: -
        Resources ............: -
        Parallelism ..........: 1

  ....


[Normal] From: BMA@back.ecn.purdue.edu "dlt4"  Time: 12/19/00 08:45:07
        STARTING Medium Agent "dlt4"

[Normal] From: BMA@back.ecn.purdue.edu "dlt4"  Time: 12/19/00 08:45:07
        Loading medium from slot 413 to device /dev/rmt/6m

[Normal] From: OB2BAR@civl3125cpc1.ecn.purdue.edu "MSSQL70"  Time: 12/19/00 08:46:03
        Starting OB2BAR Backup: master:0

[Normal] From: OB2BAR@civl3125cpc1.ecn.purdue.edu "MSSQL70"  Time: 12/19/00 8:46:03 AM
        Starting backup of database master. Required backup type is full.

[Normal] From: OB2BAR@civl3125cpc1.ecn.purdue.edu "MSSQL70"  Time: 12/19/00 8:46:03 AM
        SQL statement:
        BACKUP DATABASE [master] TO 
        VIRTUAL_DEVICE = 'OmniBack_II_master'
        WITH NAME = 'OmniBack_II: 2000/12/19 0004', BLOCKSIZE = 4096, MAXTRANSFERSIZE = 65536;

[Normal] From: OB2BAR@civl3125cpc1.ecn.purdue.edu "MSSQL70"  Time: 12/19/00 08:48:02
        Completed OB2BAR Backup: master:0


  ...

This file was created: December 19, 2000