Database Seal: Transaction Log Backup, error in translog backup

10 May 2005 11:45 AM

Biowaste

I have changed the time for the maintenanceplan but i still get the same
message, could it be something wrong with the database?

a part from the last backuplog:
[31] Database SPS01_Config_db: Transaction Log Backup...
    Destination: [D:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\SPS01_Config_db\SPS01_Config_db_tlog_200505100115.TRN]

    ** Execution Time: 0 hrs, 0 mins, 1 secs **

[32] Database SPS01_Config_db: Verifying Backup...

    ** Execution Time: 0 hrs, 0 mins, 1 secs **

Backup can not be performed on database 'VirtualCenter'. This sub task is
ignored.

End of maintenance plan 'UserDBs' on 2005-05-10 01:15:20
SQLMAINT.EXE Process Exit Code: 1 (Failed)

10 May 2005 12:48 PM

Jacco Schalkwijk

You can not perform a transaction log backup on a database that uses the
simple recovery model. Set your database to either the full or bulk_logged
recovery model and you can make transaction log backups.

--
Jacco Schalkwijk
SQL Server MVP

Show quoteHide quote

"Biowaste" <Biowa***@discussions.microsoft.com> wrote in message
news:35E8E641-6689-461A-A12C-CF1E69C08B8A@microsoft.com...
>I have changed the time for the maintenanceplan but i still get the same
> message, could it be something wrong with the database?
>
> a part from the last backuplog:
> [31] Database SPS01_Config_db: Transaction Log Backup...
>    Destination: [D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\SPS01_Config_db\SPS01_Config_db_tlog_200505100115.TRN]
>
>    ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
> [32] Database SPS01_Config_db: Verifying Backup...
>
>    ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
> Backup can not be performed on database 'VirtualCenter'. This sub task is
> ignored.
>
> End of maintenance plan 'UserDBs' on 2005-05-10 01:15:20
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>

11 May 2005 6:28 AM

Biowaste

How and where do I change that in the maint. plan?
this has worked in the past... just a few weaks ago.
how come it is only one db that fails?

Show quoteHide quote

"Jacco Schalkwijk" wrote:

> You can not perform a transaction log backup on a database that uses the
> simple recovery model. Set your database to either the full or bulk_logged
> recovery model and you can make transaction log backups.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
> "Biowaste" <Biowa***@discussions.microsoft.com> wrote in message
> news:35E8E641-6689-461A-A12C-CF1E69C08B8A@microsoft.com...
> >I have changed the time for the maintenanceplan but i still get the same
> > message, could it be something wrong with the database?
> >
> > a part from the last backuplog:
> > [31] Database SPS01_Config_db: Transaction Log Backup...
> >    Destination: [D:\Program Files\Microsoft SQL
> > Server\MSSQL\BACKUP\SPS01_Config_db\SPS01_Config_db_tlog_200505100115.TRN]
> >
> >    ** Execution Time: 0 hrs, 0 mins, 1 secs **
> >
> > [32] Database SPS01_Config_db: Verifying Backup...
> >
> >    ** Execution Time: 0 hrs, 0 mins, 1 secs **
> >
> > Backup can not be performed on database 'VirtualCenter'. This sub task is
> > ignored.
> >
> > End of maintenance plan 'UserDBs' on 2005-05-10 01:15:20
> > SQLMAINT.EXE Process Exit Code: 1 (Failed)
> >
>
>
>

11 May 2005 6:33 AM

Tibor Karaszi

This is a database option, not something you set in the maint plan. EM, right-click the database,
properties, options.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quoteHide quote

"Biowaste" <kalmeb***@hotmail.com> wrote in message
news:85A3F0C2-62B8-47E2-B424-09A2B5B245A4@microsoft.com...
> How and where do I change that in the maint. plan?
> this has worked in the past... just a few weaks ago.
> how come it is only one db that fails?
>
> "Jacco Schalkwijk" wrote:
>
>> You can not perform a transaction log backup on a database that uses the
>> simple recovery model. Set your database to either the full or bulk_logged
>> recovery model and you can make transaction log backups.
>>
>> --
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>>
>> "Biowaste" <Biowa***@discussions.microsoft.com> wrote in message
>> news:35E8E641-6689-461A-A12C-CF1E69C08B8A@microsoft.com...
>> >I have changed the time for the maintenanceplan but i still get the same
>> > message, could it be something wrong with the database?
>> >
>> > a part from the last backuplog:
>> > [31] Database SPS01_Config_db: Transaction Log Backup...
>> >    Destination: [D:\Program Files\Microsoft SQL
>> > Server\MSSQL\BACKUP\SPS01_Config_db\SPS01_Config_db_tlog_200505100115.TRN]
>> >
>> >    ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> >
>> > [32] Database SPS01_Config_db: Verifying Backup...
>> >
>> >    ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> >
>> > Backup can not be performed on database 'VirtualCenter'. This sub task is
>> > ignored.
>> >
>> > End of maintenance plan 'UserDBs' on 2005-05-10 01:15:20
>> > SQLMAINT.EXE Process Exit Code: 1 (Failed)
>> >
>>
>>
>>