• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 690
  • Last Modified:

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?
0
canuckconsulting
Asked:
canuckconsulting
1 Solution
 
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
 
Eugene ZCommented:
check if the backup is from correct db - db with tables
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now