x

[Closed] sql server 2008 restore error

previously i have restored the database which is in the 2005 but DB is in 2000 compatability, and now i am getting the error,i have restored the db in sql server 2008, when i restore the db i am getting this erroralt text

i am getting the error , what i have to do now, please help me
more ▼

asked Sep 02, 2010 at 03:40 AM in Default

ramesh 1 gravatar image

ramesh 1
2.2k 63 67 69

You asked something similar just the other day: http://ask.sqlservercentral.com/questions/18175/sql-server-restore-errror

Did those answers not help, or is this a new problem?
Sep 02, 2010 at 04:19 AM WilliamD
I've got this strange sense of deja vu...
Sep 02, 2010 at 04:56 AM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left

The question has been closed Sep 03, 2010 at 08:57 AM by Kev Riley for the following reason:


1 answer: sort voted first

The only reasons I know for this error are:

  1. You are trying to restore a database from a new version of sql server onto an older version (SQL 2008 created database onto a SQL 2005 server)
  2. The backup file is somehow corrupt

The answer to these two would be:

  1. You cannot restore a database created in a newer version of sql server to an older one - compatibility mode makes no difference here
  2. Make a new backup or try a different backup.
more ▼

answered Sep 02, 2010 at 04:17 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

+1 I agree. It really sounds like the restore is running on the wrong version.
Sep 02, 2010 at 04:37 AM Grant Fritchey ♦♦
And more deja vu. I'm sure I went through all this a while ago. Still, have a +1!
Sep 02, 2010 at 04:56 AM ThomasRushton ♦
After running your backups it is a good to use the RESTORE VERIFYONLY option to ensure that the backup that was just created is readable. Will boost your confidence about your backups
Sep 02, 2010 at 05:19 AM Cyborg
@Cyborg - too true. A backup itself is useless. A restored backup on the other hand... that can save a career or even a company!
Sep 02, 2010 at 05:22 AM WilliamD
you said it right "save a career or even a company and many families!" :-)
Sep 02, 2010 at 05:29 AM Cyborg
(comments are locked)
10|1200 characters needed characters left

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x102

asked: Sep 02, 2010 at 03:40 AM

Seen: 812 times

Last Updated: Sep 02, 2010 at 04:58 AM