December 13, 2013 at 4:20 am
Hello Masters,
My Full backup on SQL Server 2005 failed with below error:
Error: 18210, Severity: 16, State: 1. operating system error 2(error not found).
What does it mean? My OS is working fine.
Note: OS is Windows server 2003.
December 13, 2013 at 5:40 am
this is not OS related problem, Verify that the specified path has sufficient disk space for the file, also make sure specified path has required permissions in place for SQL Agent account.
December 13, 2013 at 6:18 am
Yep. Almost definitely disk space.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 13, 2013 at 6:23 am
If you were out of space at the time but are fine now, you may need to consider how you're taking backups and then removing the old ones. If you're taking a full backup and then cleaning up old backup files (IMHO, this is the right way to do it), you need to remember the order in which things are run. You need the space available to take your full backup. Then your cleanup fires, freeing up the space consumed by the oldest backup. This means that you take the size of a current full backup and multiply it by the number of days of backups you maintain plus one. For example, if you keep 5 days worth of backups, you need your_total_backup_size * 6 on the drive.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply