Missing .bak files in SQL Server Maintenance Plan
Posted on 2012-09-15
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?