How did this happen? I do not know, so I open up the maintenance plan and look at the settings. Looking at the Physical_device_name column below, I can see that the backup is going into the root drive location instead of the database named directory. You just need to change the “ database_name” parameter for the database you want to search for. WHERE database_name = 'cityworkstest' and physical_device_name like '%gisbkup%' JOIN m ON b.media_set_id = m.media_set_id I then run this script to show me where the files are. Here is a screenshot of the Agent job history, showing that the transaction log backup completed successfully.īut when I look in the directory, the transaction log backups are not there.
Finding the location of any backup commands can be found using a simple sql statement. A client of mine setup backups on their server and the jobs are running successfully, but the backups are not showing up in the backup location.
0 kommentar(er)
