x
login about faq Site discussion (meta-askssc)

[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 '10 at 03:40 AM in Default

ramesh 1 gravatar image

ramesh 1
1.8k 48 64 68

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 '10 at 04:19 AM WilliamD

I've got this strange sense of deja vu...

Sep 02 '10 at 04:56 AM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left

The question has been closed Sep 03 '10 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 '10 at 04:17 AM

WilliamD gravatar image

WilliamD
25.4k 16 18 41

+1 I agree. It really sounds like the restore is running on the wrong version.

Sep 02 '10 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 '10 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 '10 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 '10 at 05:22 AM WilliamD

you said it right "save a career or even a company and many families!" :-)

Sep 02 '10 at 05:29 AM Cyborg
(comments are locked)
10|1200 characters needed characters left

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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x95

asked: Sep 02 '10 at 03:40 AM

Seen: 557 times

Last Updated: Sep 02 '10 at 04:58 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.