Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My environment is Windows Server Standard 2003 SP2, SQL Server 2000 SP4 with a few additional patches, NetBackup Admin console 7.1 and NetBackup Client 6.5.3.

I take nightly full backups that restore with no problem. I also perform nightly server backups with NetBackup. After a native backup has been backed up with NetBackup to tape and subsequently restored to disk from tape it fails with the 'SQL-DMO(ODBC SQLState: 42000) An internal consistency' error. The RESTORE VERIFYONLY indicates that the backup set is valid. This restore has been attempted on server native backups with no success.

These restores are being done on the server that acted as the source so there is no issue with patch level, etc. between different servers.

Many other types of files have been restored with no apparent problem (Excel, .pst, .SLS).

Any help with this would be appreciated.


The NetBackup strategy currently being used was implemented in March against Virtual Servers on VMWare using the 'flash' methodology.

This error appears only to happen with SQL Server 2000 and .BAK files larger than 2G.

share|improve this question
add comment

1 Answer

If anyone is unlucky enough to encounter this also, check out the link http://www.symantec.com/business/support/index?page=content&id=TECH160324 and see that it is a default parameter value that may be causing the problem. Changing the default value resolved the problem.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.