This issue has been puzzling me for some time now and I'm running out of ideas! Any help would be much appreciated! Here's the problem:
MS SQL Server 2008 running on Windows Server 2008R2 (Virtualized) Database backups are failing for all (larger) Databases on a particular server. Error code 27 suggests "The drive cannot find the sector requested.".
There is plenty of available space on backup drive, and I have tried backing up to other drives on the server which also fail.
I am able to backup the system databases without any trouble. (presumably due to their small size)
I created a new blank database and was able to back this up.
Manual backups of the main Databases fail (using 'right click' or TSQL). They get to 30% and the fail as if they have run out of space.
This is a virtual server running on a two node cluster. I've tried failing the VM to the other node, but this doesn't help.
Tried splitting the backup into five parts, but the job starts hanging again at 30%.
I tried manually copying one of the old backups to the drive using Windows Explorer. The file copied successfully.
It feels like a problem with the drives, however it's only an issue from within SQL Server.