Click here to Skip to main content
13,455,909 members (51,845 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
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.
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?
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 |
Web03 | 2.8.180322.1 | Last Updated 14 Apr 2017
Copyright © CodeProject, 1999-2018
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