Backup successful but shows failed

Question

Post reply

Backup successful but shows failed

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

SkyBVI SSCoach Points: 15128 More actions · Answer 1

@ YTZ

Ya, i checked the database size of previous backups

there is not much difference.

I guess some verifying backup integrity or maintenance plan failed

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Matt S.-364742 SSC Enthusiast Points: 183 More actions · Answer 2

I've run into a similar problem before and used RESTORE VERIFYONLY to check the success of the backup.

http://technet.microsoft.com/en-us/library/ms188902.aspx

I think (but am not sure) that the filesize gets allocated when the backup job starts so a similar filesize may be misleading.

Jinu43 Ten Centuries Points: 1237 More actions · Answer 3

Did you or someone else delete the database from your server recently?

In your SQL Server 2005, can you please check which service pack you have?

SkyBVI SSCoach Points: 15128 More actions · Answer 4

@jinesh

No one deleted the database,

the sql server version is 9.00.4053.00 SP3 standard edition

Regards
Sushant Kumar
MCTS,MCP

Jinu43 Ten Centuries Points: 1237 More actions · Answer 5

I had a same problem few months back because one of developer Deleted one DB from our Production Environment. On that server we have SQL 2005 and SP2.

What i did that time----

Created New Database Maintenance Plan same as old one and disable the old Database maintenance Plan for week and monitor it.

It works for me.

After a week i deleted old Plan.

try it may be it works......

Cheveri SSC Rookie Points: 40 More actions · Answer 6

Checking maintenance plan history would help.

select * from msdb.dbo.sysmaintplan_log

select * from msdb.dbo.sysmaintplan_logDetail

The databases selected for backup (in SSIS package) and the current databases in the server may not be matching. In that case it would work after saving or re-creating the m-plan.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 7

jineshpatel43 (8/28/2010)
I had a same problem few months back because one of developer Deleted one DB from our Production Environment.

DB dropped by developer ??? very strange thing. why developers have admin level rights to developers ? just curious to know.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)