Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Restore a SQL Server 2012 backup to SQL Express 2012

Posted on 2013-01-28
4
Medium Priority
?
685 Views
Last Modified: 2013-02-04
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
Comment
Question by:canuckconsulting
4 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 38828931
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
 
LVL 40

Expert Comment

by:lcohan
ID: 38828932
"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
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 38828934
check if the backup is from correct db - db with tables
0
 

Author Closing Comment

by:canuckconsulting
ID: 38851017
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question