Missing .bak files in SQL Server Maintenance Plan

It's been a while since I've used SQL Server, so I'm getting back up to speed.

A client has a SQL Server database which has not been backed up regularly for months.  I'm configuring a maintenance plan, setup to do differential backups of the database nightly and full backups weekly.

My full backup procedure is supposed to backup the database to:

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup

with Create a sub-directory for each database checked, and then shrink the database.

I executed the maintenance plan, and the log indicates that it executed successfully, but there are not .bak files on that path, and when I searched the entire C:\ drive there were no recent .bak files on the entire drive.

Any ideas what is going on?
LVL 50
Dale FyeAsked:
Who is Participating?
 
TempDBAConnect With a Mentor Commented:
I would recommend you to manually debug the code. May be it is creating the bak file somewhere else. You can find whether backup was done or not by checking backuphistory in msdb database

SELECT sdb.Name AS DatabaseName,
COALESCE(CONVERT(VARCHAR(12), MAX(bus.backup_finish_date), 101),'-') AS LastBackUpTime
FROM sys.sysdatabases sdb
LEFT OUTER JOIN msdb.dbo.backupset bus ON bus.database_name = sdb.name
GROUP BY sdb.Name
0
 
Dale FyeAuthor Commented:
TempDBA,

OK, that tells me that the backup did not actually run, because none of the "LastBackupTimes" actually were today.  I created a new maintenance plan with a "Backup Database Task" for all the databases.  Same configuration as above, and it worked.

Thanks for the assistance.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.