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?
canuckconsultingAsked:
Who is Participating?
 
Eugene ZCommented:
check if the backup is from correct db - db with tables
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
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  )
0
 
lcohanDatabase AnalystCommented:
"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.
0
 
canuckconsultingAuthor Commented:
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..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.