Link to home
Start Free TrialLog in
Avatar of canuckconsulting
canuckconsultingFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Restore a SQL Server 2012 backup to SQL Express 2012

I am having problems restoring a SQL Server 2012 db to SQL Express 2012. I do the backup from SQL Server and then restore it with overwrite without error.  The problem is the restored DB is missing al the tables.  Am I doing something wrong?
Avatar of Aneesh
Aneesh
Flag of Canada image

did you check how big the source database is ? there is a space limitation on SQL 2012 express edition (Max database size allowed is 10Gig  )
"The problem is the restored DB is missing al the tables.  Am I doing something wrong?"

Are you accessing it with SQL SA or sysdmin rights or at least the EXACT same account as from the SQL 2012? My guess is that you don't have access to see the schema objects for whatever reason.
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of canuckconsulting

ASKER

Sadly this was the case.  I had assumed that my orginal db was intact but appears at some point it was wiped out.  Thanks for help with what ended up me being stupid..