asked
Restore of full database backup
Today I faced a problem of restoring database backup, consist about 20GB, before a week, I restored backup simple and fast as usually, today it takes hours and hours to restore, what can be problem in here? I faced some errors like: FCD::Cannot open file..
OK Comment list getting a little long..... Can you confirm that the file does actually exists in the location you think it is? Could there be any other process accessing the file (NAS/disk/tape backups, anti-virus scans, etc)? Is the backup from the same server that it is being restored on or another server?
Can you write files to the locations given in the error messages? D: and F: would appear to be the target drives...
You might also want to check the state of the drive / array controller. And make sure that all drivers are up-to-date. It definitely feels like something's not happy at the storage / IO level.
What are D: and F: - are they local drives to the server, drives on a SAN?
Are D: and F: on the same physical drives? If they are an array, have you checked that the array is in good order? If it has lost a drive and is rebuilding the IO will suffer. Check the hardware is in good order
Based on the errors it looks like you are trying to restore to the root of the drives. Create folders on the drives to restore into and ensure that the SQL Server service has full NTFS access permissions.
@Gogolo - that is a possibility. Are you seeing any events in the Windows logs or in the Array logs? Have you tried my suggestion? It is to determine if permissions are a factor. By changing your restore to C: you have identified that there is an issue on the other drives but not what it is yet.
From all the other comments it sounds like your RAID array is taking a hit. Is Drive C: a different array, possibly RAID 10, then you have another set of disks for D: and F:. When I first started reading your post I was thinking maybe you had a bad drive and the array was having to rebuild a spare, but with the errors you are getting trying to write to the disk makes me think you have bad sectors. I would recommend running a scan disk on the drive to rule that out. Are you pretty familiar with RAID and can look at the RAID Manager software to check for errors? If not get your systems guy to take a look. Windows Event Viewer might also contain some good information as to what is going on with the disk subsystem.
Since you can restore to C: your backup file is good. The errors you are getting is trying to write to D: and F: which wreaks of corruption on your RAID 5 array. Is your database even accessible or is it having issues which is what is causing you to have to restore from backup? Your RAID management software should have more information about the root of the error and quite possibly the windows event log. Do you have physical access to the server to see if you have amber lights on the disks? I assume this is local raid with hot swap drives.
