Maintenance plan complains after replacing databas

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Maintenance plan complains after replacing databas

Author

Topic

SQLsearcher
Starting Member

47 Posts

Posted - 2005-07-12 : 02:44:52

Hello All

I have a maintenance plan (Daily) which, amongst others, backs up the transaction log of a database. On the development server I replaced a database with the production version. Next the maintenance plan (Daily) starts complaining it cannot back up the transaction log. This I can understand. But it keeps complaining even after running the maintenance plan (Weekly) which backs up the entire database.
I think I have to reset / clear / reinitialize a maintenance plan or something. Please advise.

Kind regards, SqlSearcher

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-07-12 : 04:46:51

error message please...

--------------------
keeping it simple...

SQLsearcher
Starting Member

47 Posts

Posted - 2005-07-12 : 05:06:30

Hello Jen

Management > Database Maintenance Plans

Activity: Backup transaction log
Status: Failed
Message: Backup can not be performed on this database. This sub task is ignored

Management > SQL Server Logs
No information

The event log of the server did not show any additional information.

I didn't think these messages were very helpfull. If you know an other source of error messages please inform me.

Kind regards, SqlSearcher

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-07-12 : 05:26:42

Is the recovery model of the database set to FULL so the logs can be backed up?

Andy

Beauty is in the eyes of the beerholder

SQLsearcher
Starting Member

47 Posts

Posted - 2005-07-12 : 05:39:51

Hello AndyB13

Oops. Something went wrong during copying (I didn't pay enough attention). The recovery model was set to Simple. I changed it to Full. Do I have to reset anything, or will SQL Server perform a full backup previous to a transaction back up?

Thanks, SqlSearcher

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-07-12 : 06:05:18

You shouldnt have to "reset" anything but SQL server will perform whatever backup is next in the schedule. However, I would do a "manual" back up straight away

Andy

Beauty is in the eyes of the beerholder

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources