August 28, 2003 at 11:33 am
Hi All,
I use Seagate BackupExec to back up my sqlserver database to tape. It looks like all of the database got backed up except the model db. The event log gave me this kind of message: "An error occurred while executing the following query: "BACKUP DATABASE [model] FILEGROUP='PRIMARY' TO virtual_device = 'BackupExecSqlAgent_PRIMARY_00'".
On server: "SQLSERVER".
SQL error number: "0BD3".
SQL error message: "Could not find filegroup 'PRIMARY' in sysfilegroups for database 'model'."
Can someone please let me know what is the real reason since I check the filegroup for msdb and it had the filegroup 'Primary'. Thanks
Minh Vu
August 28, 2003 at 4:09 pm
I've seen this before, but MS don't seem to have acknowledged it as a bug. It will happen even if you do a straight FILEGROUP backup for model from Query Analyzer. Filegroup backups of other full-recovery databases don't have the same problem.
Others have noticed it too, and it's nearly always BackupExec that has the problem. I think it's because BackupExec is the only product that would attempt a filegroup backup on model. Why would it do so?
Can you configure BackupExec to do a normal FULL backup on model? Alternatively, can you schedule a native backup to disk for model, then let backupexec pick up the BAK file from the file system?
Cheers,
- Mark
Cheers,
- Mark
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply