SQL Buddies...lol

Discussion in 'Windows Small Business Server' started by Maxibo, Jan 5, 2006.

  1. Maxibo

    Maxibo Guest

    Hi, I won't pretend I am an SQL expert... ;-)

    Client has veritas backup but not the sql agent, backing up all C drive....
    will this allow recover of SQL ? If so why would someone need the sql agent.

    On that point does the Microsoft Backup facility cater for SQL

    Many THanks
     
    Maxibo, Jan 5, 2006
    #1
    1. Advertisements

  2. Maxibo

    Al Williams Guest

    I'm using NTBACKUP, and whenever it backs up a volume using shadow copy it
    always generates a MSSQLSERVER event 17055 in the app log for each database
    it encounters on that drive. This event is the same one generated if you
    used the SQL Enterprise Manager to backup the database manually or on a
    schedule. This implies NTBACKUP is automatically handling backing up SQL or
    MSDE databases - no agent needed.

    I used to use third party backup but I've found NTBACKUP, while a bear to
    configure, worked quite well in my case.
     
    Al Williams, Jan 5, 2006
    #2
    1. Advertisements

  3. Maxibo

    ChipW Guest

    Using Enterprise Manager, you can setup a backup schedule in similar fashion
    to the SBS backup wizard ie number of backup to keep, how often, which
    database, etc. It will default saving the backup to the SQL backup
    directory, which your Full drive backup will cover too.

    Good Luck
    Chip
     
    ChipW, Jan 5, 2006
    #3
  4. Except that that would require the SQL Server Agent [1] service to be
    running, which by default, is not the case with MSDE.
     
    Steve Foster [SBS MVP], Jan 6, 2006
    #4

  5. The Veritas SQL Agent allowed BE to interface to SQL such that a backup
    request would cause SQL to hold transactions while the backup was performed.

    With the shadow copies capability of WS2003, the regular file-based backup
    is able to achieve the same end result.
     
    Steve Foster [SBS MVP], Jan 6, 2006
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.