Backup is successful but the backup is not on the folder!

Question

question

DaniSQL asked Feb 25, '10

Backup is successful but the backup is not on the folder!

Hi All,

I have a backup scheduled (daily full and transactional every hour) on one of the servers and the the backup plan job is successful everyday. No errors at all. But there is not Full backup at all on the folder for the last four days. Does this thing happen to anyone of you? If it is a known issue please tell me how you solve it.

Thanks,

sql-server-2005 backup

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-02-25T19:00:00Z

TimothyAWiseman answered Feb 25, '10

I have more questions than answers.

First, just to check the obvious, are you certain you are pointing it to that folder and not having it save somewhere else? I have done that one myself.

Does it work as expected with a file actually produced if you run it manually instead of through the job?

Are you using SQL Server 2005's native backup capabilities or using a 3rd party solution such as Red Gate SQL backup?

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL commented · Feb 25, 2010 at 07:41 PM

Timothy, I am using native/builtin maintenance plans; Yes it is pointing to the right folder. It worked for me now with new TSQL script with out automating it as a job. Also the environment is x64 SQL2005 RTM.

0 ·

Answer 2 · 2010-02-25T17:26:12Z

CirqueDeSQLeil answered Feb 25, '10

Has the job been successful prior to the last four days?

If so, what has changed?

If not, can you add logging to your maintenance plan and run the plan again? After running the plan again, you would be able to read the log and find any errors that were encountered.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL commented · Feb 25, 2010 at 06:49 PM

Yes Job was successful and it's still successful. But for the last 4 days the job runs only 3 seconds(it usually takes 10 min). I run the job again and No error logs at all.

0 ·

Answer 3 · 2010-02-26T05:29:54Z

David Wimbush answered Feb 26, '10

Try the standard report in Management Studio that shows backup and restore events. (Right click on the database in Object Explorer.) It's not very obvious but if you click on the + in the Device Type column it will show you the file name the backup was written to. There's also a section that shows backup errors. Does that give you any clues?

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL commented · Feb 26, 2010 at 08:45 PM

I know which folders are the backups going to be placed, but the last four days the backup job was not working properly. I saw the history and all backup jobs run for 2 or 3 seconds even though it says the job completed successfully. Had it failed, I would have gotten email alert.

0 ·

Answer 4 · 2010-02-26T06:29:34Z

philcart answered Feb 26, '10

Are you checking the history/status of the SQL Agent job, or the Maintenance Plan?

Right-click on the maintenance plan in Object Explorer and choose View History.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL commented · Feb 26, 2010 at 08:43 PM

I check both. I also checked the text log file. I saw the history and no error at all. it says the job is successful but the job runs for three seconds and no backups were taken.

0 ·

question