Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2012-04-18 : 21:07:41
|
| I am runningbackup database mydb to disk ='C:\sqlbackups\daily\mydb.bak' with initthe file doesn't exist but I want it to create a backup (and then each time I run overwrite the backup)I am getting an errorMsg 3271, Level 16, State 1, Line 1A nonrecoverable I/O error occurred on file "C:\sqlbackups\daily\mydb.bak:" 112(failed to retrieve text for this error. Reason: 15105).Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-04-19 : 01:40:45
|
| 1)Have you run DBCC CHECKDB?2) Have you checked disk space?3)Check SQL Server Logs4) Check Windows Logs5) Have you tried to back it up to another drive?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2012-04-19 : 07:04:28
|
| yes the issue was there wasn't enough disk space (there was enough for the backup but apparantly it needed more to run)I wish I could figure out why my database is 8 gb - it's big but not that big |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-04-19 : 07:59:37
|
| Check the size of the log file. It may have larger sizeMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
backup error