Solved

sql 2008 database restote

Posted on 2011-09-22
2
420 Views
Last Modified: 2012-05-12
i have taken backup on sql 2008 server(running version 10.50.1600). i want to restore the database on sql 2008 (running version 10.00.1600).  when i try to restore it give me error
Restore failed for server 'servername',(Microsoft.sqlserver.smoextended)

additional informataion : -
system.data.sqlclient.sqlerror: the database was backed up on a server running version 10.50.1600. that version is incompatible with this server, which is running version 10.00.1600. either restore the database on a server that supports the backup, or use a backup that is compatible with server. (microsoft.sqlserver.smo)

how to restore backup?

0
Comment
Question by:nitin_s_shah
2 Comments
 
LVL 25

Accepted Solution

by:
TempDBA earned 500 total points
ID: 36581826
You can't restore a database from higher version to lower version. This is a case that I saw before where a backup from SQL Server 2008 R2 was being restored in SQL Server 2008. The case looks like similar to yours. Please find the attached link

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/45be2608-4563-4a3a-8a3a-51a9e030c051/
0
 

Author Closing Comment

by:nitin_s_shah
ID: 36585131
explained very clearly. thanks
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql join/ assign small # first 10 83
Concatenating multiple comments into one row 16 62
email the result out from a T-SQL queries 29 64
the whoisactive update 12 39
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

863 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

22 Experts available now in Live!

Get 1:1 Help Now