Free for PREMIUM members
Go Premium for a chance to win a PS4. Enter to Win
Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.
ALTER DATABASE DatabaseName SET COMPATIBILITY_LEVEL = 90
Open in new window
the database Internal Version Number is 515, but compatibility is 2000. if I take a backup from it and restore in any other 2005 instance, it is fine; but if I take it to 2008R2, it fails. (not able to upgrade).
DBCC CHECKDB WITH DATA_PURITY
and I got this: (gone from 515 to 706.. does not make sense?!)
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.