I have been using SQL Server 2012 during some years. I was working during all the night yesterday evening. After I almost finished my work, I tried saving my changes, and SQL Server stopped responding and it was closed. I opened it again and I got Corruption on data pages. I've no idea what to do next. I applied SQL Server Management Studio, but it was useless.
Pat, there is a tutorial below, especially for cases like your, in case nothing helped typed in Google mssql database repair tool – it is one of the most popular queries, on it Google gave following articles, guides, etc…
There might be other options out there. This is something that worked for me once but there are no guarantees that it will work at all times.
Stop SQL Server instance -> Copy MDF and LDF files to another location -> Delete original MDF and LDF files -> Start SQL Server instance again -> Create new database with exact same name and file names -> Stop SQL Server -> overwrite newly created MDF and LDF.
After this your database should be back online. If it is then go ahead and put it into EMERGANCY mode and SINGLE USER mode.
Finally go ahead and execute DBCC CHECKDB like this
DBCC CHECKDB (databaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS
If you can get to this and execute last command successfully, you should be good on.