question

DaniSQL avatar image
DaniSQL asked

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-2005backup
10 |1200

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

TimothyAWiseman avatar image
TimothyAWiseman answered

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 comment
10 |1200

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

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 Likes 0 ·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

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 comment
10 |1200

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

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 Likes 0 ·
David Wimbush avatar image
David Wimbush answered

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 comment
10 |1200

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

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 Likes 0 ·
philcart avatar image
philcart answered

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 comment
10 |1200

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

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 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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