debugsqlMinor
On SQL Server Backup: Msg 3271, Level 16, State 1, Server Line 1 A nonrecoverable I/O error occurred on file
Viewed 0 times
errormsgfilelinesqllevelnonrecoverablestateserveroccurred
Problem
I am trying to back up a pretty big database and I keep getting this error:
Does anyone happen to know what this is?
Msg 3271, Level 16, State 1, Server {Server Name}, Line 1 A
nonrecoverable I/O error occurred on file "{Backup File Location}:"
112(failed to retrieve text for this error. Reason: 1815). Msg 3013,
Level 16, State 1, Server {Server Name}, Line 1 BACKUP DATABASE is
terminating abnormally.Does anyone happen to know what this is?
Solution
So after many google searches and realizing that there was very little space left on the drive that I was trying to back up to, I found the issue.
Resolution: There is not enough space on the drive to fit the backup.
That seems like something that would be pretty easy to display Microsoft!!
Hope this helps someone else
Resolution: There is not enough space on the drive to fit the backup.
That seems like something that would be pretty easy to display Microsoft!!
Hope this helps someone else
Context
StackExchange Database Administrators Q#21960, answer score: 5
Revisions (0)
No revisions yet.