Solved

BackUp the database from Sql server 2008 Developer edition and restore it in sql server 2008 Express edition

Posted on 2011-09-12
2
320 Views
Last Modified: 2012-05-12
I do have my database in in developer edition and I took back up of the database and now I want to restore database in express edition...It is giving me error that is attached.

Please give me some solution..I am trying since so long
error.png
0
Comment
Question by:Itgirl16
2 Comments
 
LVL 10

Accepted Solution

by:
ThorinO earned 500 total points
Comment Utility
It looks like your source is 2008 R2 and the destination is 2008. Can you upgrade your express edition to the same build number that the source is?

http://support.microsoft.com/kb/321185
0
 

Author Closing Comment

by:Itgirl16
Comment Utility
Really nice solution.I appriciate it.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now