Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Full backup failed Expand / Collapse
Author
Message
Posted Friday, December 13, 2013 4:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 5:51 AM
Points: 203, Visits: 538
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.
Post #1522628
Posted Friday, December 13, 2013 5:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:24 AM
Points: 147, Visits: 584
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.



Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1522639
Posted Friday, December 13, 2013 6:18 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:38 AM
Points: 14,824, Visits: 27,299
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1522652
Posted Friday, December 13, 2013 6:23 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:40 PM
Points: 3,316, Visits: 2,364
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.


Tally Tables - Performance Personified
Best practices on how to ask questions
Post #1522654
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse