debugMinor
SQL Server 2008 R2 Restore Database From File - "failed: 38(failed to retrieve text for this error. Reason: 15105)"
Viewed 0 times
thisfileerror2008sqltext15105databaseretrievereason
Problem
I'm running a database restore on a backup file that was created up on a clients server, the backup file has been moved to our server (same SQL version 2008 R2) and I'm getting the following error after the T-SQL has been running for nearly 7 minutes:
TSQL:
Error:
TSQL:
RESTORE DATABASE [Charms_OrangeGrove]
FROM DISK = N'S:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\Charms_OrangeGrove_290114.bak'
WITH MOVE N'CharmsData_dat'
TO N'S:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Charms_OrangeGrove.mdf',
MOVE N'CharmsData_log'
TO N'S:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Charms_OrangeGrove_Log.ldf'Error:
Msg 3203, Level 16, State 1, Line 1
Read on "S:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\Charms_OrangeGrove_290114.bak"
failed: 38(failed to retrieve text for this error. Reason: 15105)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.Solution
It looks like you are having a disk read problem or perhaps a corrupted backup.
I would try
Here is a link where someone had a similar problem. It has some additional steps he tried and mentions that he had a hardware problem.
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/2a127a18-dfd0-4668-afc4-f5eb497f4977/sql-server-2008-restore-fails-msg-3203?forum=sqldisasterrecovery
I would try
a. Run RESTORE VERIFYONLY FROM DISK =
N'S:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\Charms_OrangeGrove_290114.bak'
b. If it comes up clean try copying it to a different location
(preferably a different drive on different physical hardware)Here is a link where someone had a similar problem. It has some additional steps he tried and mentions that he had a hardware problem.
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/2a127a18-dfd0-4668-afc4-f5eb497f4977/sql-server-2008-restore-fails-msg-3203?forum=sqldisasterrecovery
Code Snippets
a. Run RESTORE VERIFYONLY FROM DISK =
N'S:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\Charms_OrangeGrove_290114.bak'
b. If it comes up clean try copying it to a different location
(preferably a different drive on different physical hardware)Context
StackExchange Database Administrators Q#57805, answer score: 5
Revisions (0)
No revisions yet.