Click here to Skip to main content
13,149,756 members (77,635 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
I am trying to import the .DAT database to SQL server 2008. Then error occurred.

What I have tried:

How can I solve this error and Successfully import the database ?
[^]
Posted 14-Apr-17 16:27pm
Updated 14-Apr-17 17:26pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

You can't. You're trying to restore a backup from a newer version of SQL Server to an older version. That's not going to work.

You have no choice but to either upgrade the SQL Server version on the machine you're trying to restore to or build a new SQL Server with the same version the backup was taken from.
  Permalink  
Comments
Member 12955507 15-Apr-17 0:23am
   
But, I am using SQL Server 2008 both in the office and on my PC. This is huge data base. So I can not create a script.sql
Member 12955507 15-Apr-17 0:28am
   
In sql server 2008, is this work for me? http://stackoverflow.com/questions/431913/how-do-you-import-a-large-ms-sql-sql-file
Dave Kreskowiak 15-Apr-17 9:51am
   
Downvote me all you want. That's exactly what the error message is telling you. Perhaps you don't have the same service pack installed?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web04 | 2.8.170924.2 | Last Updated 14 Apr 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100