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.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.|||What version of veritas are you using ?|||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.|||Originally posted by rnealejr
What version of veritas are you using ?
version 8|||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 ?
No comments:
Post a Comment