Results 1 to 6 of 6

Thread: Database Backup

  1. #1
    Join Date
    Dec 2003
    Location
    New York, NY
    Posts
    3

    Question Unanswered: Database Backup

    I was taking backup of my databases using veritas. I got following errors. Does anyone know how can I fix these?
    Thanks

    Backup started on 12/10/2003 at 11:42:27 PM.
    Database pubs
    Database Northwind
    Database msdb
    Database model
    Database master
    Database Dimoda_MS
    Database DBTalk
    Database filegroup from DBTalk
    PRIMARY
    Database filegroup from Dimoda_MS
    PRIMARY
    Database filegroup from model

    An error occurred on a query to filegroup model..PRIMARY.
    ^ ^ ^ ^ ^
    Could not find filegroup 'PRIMARY' in sysfilegroups for database 'model'.
    ^ ^ ^ ^ ^
    Unable to open the item model?PRIMARY - skipped.
    Database filegroup from msdb

    An error occurred on a query to filegroup msdb..PRIMARY.
    ^ ^ ^ ^ ^
    The statement BACKUP DATABASE...FILE=<name> is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
    ^ ^ ^ ^ ^
    Unable to open the item msdb?PRIMARY - skipped.
    Database filegroup from Northwind

    An error occurred on a query to filegroup Northwind..PRIMARY.
    ^ ^ ^ ^ ^
    The statement BACKUP DATABASE...FILE=<name> is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
    ^ ^ ^ ^ ^
    Unable to open the item Northwind?PRIMARY - skipped.
    Database filegroup from pubs

    An error occurred on a query to filegroup pubs..PRIMARY.
    ^ ^ ^ ^ ^
    The statement BACKUP DATABASE...FILE=<name> is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
    ^ ^ ^ ^ ^
    Unable to open the item pubs?PRIMARY - skipped.

    Backup completed on 12/10/2003 at 11:43:01 PM.

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Database Backup

    I think this is a better question to Veritas than to SQL since you are not using SQL backup. It's possible that Veritas can't access the system database in SQL.

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    What version of veritas are you using ?

  4. #4
    Join Date
    Dec 2003
    Location
    New York, NY
    Posts
    3

    Re: Database Backup

    Originally posted by joejcheng
    I think this is a better question to Veritas than to SQL since you are not using SQL backup. It's possible that Veritas can't access the system database in SQL.
    Quite possible.. Could you tell me what would be the better way of taking backup. Additionaly, do I need to take the backup of the system databases.

  5. #5
    Join Date
    Dec 2003
    Location
    New York, NY
    Posts
    3
    Originally posted by rnealejr
    What version of veritas are you using ?
    version 8

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Are you attempting to backup the logs on these databases ? If so, if your recovery model is simple - the log file cannot be backed up. Also, in veritas, did you select the database to backup or the filegroups ?

Posting Permissions

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