I am newbie in the world of Database administration, so excuse my stupid question :)
I have the following maintenance jobs scheduled through SQL Server Management Studio :
- Full DB Backup at 2 am, 10 am & 6 Pm daily (after every 8 hours).
- Transactional log backup at 2:30 am daily.
- Shrink job at 9:30 am & 9:30 pm daily.
I have run the Shrink job at about 1 AM manually, after that the scheduled Transaction Log Backup got failed with following error
Code: 0xC002F210 Source: Back Up Database (Transaction Log) Execute SQL Task Description: Executing the query "BACKUP LOG [PRODDB] TO DISK = N'S:\CAS Backup\Log..." failed with the following error: "BACKUP LOG cannot be performed because there is no current database backup. BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query "ResultSet" property not set correctly parameters not set correctly or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 03:01:12 Finished: 03:01:12 Elapsed: 0.359 seconds. The package execution failed. The step failed.,00:00:00,0,0,,,,0
I need to understand was manually running Shrink Job before transaction log backup failed the later at 2:30 AM??