February 26, 2002 at 11:48 am
We've been using BackupExec for a while to back up our SQL 2000
databases, but we've suddenly encountered a problem while trying to back
up some of them. It seems that it won't back up databases that have a
recovery model of "simple". Our Network Admin can't find anything in
BackupExec that references Recovery Model, and we haven't changed the
recovery model on the databases since they were created .....
Here's the error from the event log ... any ideas ?
An error occurred while executing the following query: "BACKUP DATABASE
[TI] FILEGROUP='PRIMARY' TO virtual_device =
'BackupExecSqlAgent_PRIMARY_00'".
On server: "SQLDB-01".
SQL error number: "1070".
SQL error message: "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.
".
February 26, 2002 at 4:57 pm
Open Enterprise manager and right click the offending DB and open properties. You will find the recover model on one of the tabs (sorry no visual to help remember but I believe it is one of the last 2 tabs).
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
February 26, 2002 at 7:52 pm
You'll find, though, that the majority consensus is not to use 3rd party agents to do backups of SQL Server. Safer to do the backup to the file system and backup the file system.
SQL Server completely controls its own backup process, the backup utilities are designed to handle file system backups, and one doesn't have to purchase the agent license for SQL Server.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply