ASKER
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
TRUSTED BY
This path is then held and shows the next time you do a manual backup.
If you are at all interested the backup details are all stored in the system MSDB database.
As a look but don't touch task for you, put in the name of your DB in the last line of this script and you'll see a lot of information about the backups pertaining to that database....
USE msdb
GO
SELECT *
FROM Backupset b JOIN dbo.backupfile f
ON f.backup_set_id = b.backup_set_id
JOIN dbo.backupmediafamily mf
ON mf.media_set_id = b.media_set_id
WHERE Logical_Name like '%YOUR DATABASE NAME%'