Dale Fye
asked on
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\Bac kup
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?
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
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.