January 6, 2010 at 7:24 am
I am running the following restore , I need to setup mirroring for this DB
RESTORE DATABASE [LiveData_Stats] FROM DISK = N'T:\FULL_LiveData_Stats_20100103040008.BAK'
WITH REPLACE, FILE = 1,
MOVE N'LiveData_Stats_Data' TO N'R:\SQLDATA\LiveData_Stats.mdf',
MOVE N'LiveData_Stats_Log' TO N'E:\SQLLOG\LiveData_Stats2_Log.LDF',
MOVE N'LiveData_Stats_Indexes' TO N'Q:\SQLDATA\LiveData_Stats2_Indexes.ndf',
MOVE N'LiveData_Stats_STORE1' TO N'P:\SQLData\LiveData_Stats2_STORE1.ndf',
MOVE N'LiveData_Stats_Primary2' TO N'R:\Sqldata\LiveData_Stats2_Primary2.ndf',
MOVE N'StatsArchive' TO N'M:\SQLDATA\StatsArchive.ndf',
NORECOVERY, NOUNLOAD, STATS = 10
T:\drive is a SAN attached drive
I keep getting the following error after 90 percent completion:
Msg 3203, Level 16, State 1, Line 1
Read on "T:\FULL_LiveData_Stats_20100103040008.BAK" failed: 13(failed to retrieve text for this error. Reason: 15105)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I have googled this but found no joy.Anyone seen this before
Cheers
Chris
January 6, 2010 at 7:33 am
First question, are you trying to restore from a file on a shared (network drive) or from a local drive?
If from a network share, if you have room locally on the server you may want to try copying the file to a local drive and retry the restore from there.
Edit: Ignore the above. I missed the part about the SAN.
January 6, 2010 at 7:35 am
The file is 228GB and cant be copied locally
January 6, 2010 at 8:05 am
Your backup is damaged or there's an IO problem with the SAN. You can try to use CONTINUE_AFTER_ERROR, but do note that if you do so, some of the database may be missing. If you're trying to set up mirroring, I would strongly suggest you don't do that.
Can you get another backup?
Also, ask the SAN admin to do some checks of the SAN, make sure there's no problems.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply