Would welcome any thoughts, further checks I could run t help identify what is wrong with the primary file in the database. I’m pulling together a process to export all the DB objects and bulk copy all the data out into another database. Other forums suggest this error message is due to file access/permissions or not enough disk space for the backup to finish but this is not the case.Īnother option I’ve considered is detaching/stopping sql and copying the mdf,ndf, ldf files to another server, but I don't want to stop the system until I feel more confident with the data being protected. Worsening with no valid backup now for over a week. Whilst CHECKDB continues to report no errors the position is The server itself has been restarted since the recovered database was brought back online and SQL Server returned no errors. It's an 11GB database which is separated across 3 files – Primary, Data, Index. The environment is on VMWare - Windows Server 2008 R2 SP1 running SQL 2008R2 SP3, Standard Edition. The device, \Device\Harddisk2\DR2, has a bad block. Reason 15105)īACKUP DATABASE is terminating abnormally. – each time the backup gets to 70% before terminatingĢ3(failed to retrieve text for this error. The Full or a Copy_Only backups produce the same error (have also tried continue_after_error) CHECKDB remains successful across all the databases. However the daily backup have continually failed. No other corruption had shown on the system or other user databases.įollowing the restore a complete CHECKDB across the whole instance was successful and the application was brought back online. Whilst CHECKDB continues to report no errors the position is worsening with no valid backup now for over a week. The server itself has been restarted since the recovered database was brought back online and SQL Server returned no errors. Following a SAN issue one database was marked Suspect – resulting in the need to recover from backup & log backups. Its an 11GB database which is separated across 3 files Primary, Data, Index.
0 kommentar(er)
