I'm helping out someone where it looks like their previous developer stored some data tables in the Master database in SQL Server Express 2014. I don't know if it was to see if one could get around the 10GB Express database limit but either way I have inherited a problem.
I'm trying to export those 5 data tables out of the Master db in the Express instance and so we can import it into SQL Server Enterprise edition. I have successfully done a Select * from 3 of the tables and saved the results as a CSV. For some reason I couldn't get BCP working as expected.
But the last 2 tables are giving these errors below when I run the Select *. They will present records in the Result grid then stop with these errors before showing them all:
SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:289053) in database ID 1 at offset 0x0000008d23a000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\master.mdf'. ... This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB).
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x13558868; actual: 0x679e4b13). It occurred during a read of page (1:289259) in database ID 1 at offset 0x0000008d3d6000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\master.mdf'. .... This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB)
Is it possible to run DBCC CHECKDB on the Master database?
The whole thing seems pretty dicey seeing as I don't think it's supported to store user tables in Master, or just plain bad practice, no matter what version you are using.
Just wondering if there's any chance of retrieving the entire contents of these last 2 tables.
