Today while I trying to perform backup for one database using script or SQL Server 2008 management studio I got this error
BACKUP DATABASE [SCTA_ORG] TO DISK = N'E:\SQL 2008 DBs\MSSQL10.SQL2008\MSSQL\Backup\sct_org_4.bak'
WITH NOFORMAT, NOINIT,
NAME = N'SCTA_ORG-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
this is the error
Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file "E:\SQL 2008 DBs\MSSQL10.SQL2008\MSSQL\Backup\sct_org_4.bak:" 112(failed to retrieve text for this error. Reason: 1815). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is termina
ting abnormally.
Solution:
this error related to Disk space of Backup drive so to perform the backup successfully just increase the space of disk drive where the backup will be save it.
No comments:
Post a Comment