I got an error when I restored database

Hi Guys,
I got an error when I restored database. I tryed to restore a database that
is 8G. I got an error that is "An internal consistency error occured. Contac
t
technical support for assistance. RESTORE DATABASE is terminating
abnormally", then the database was marked Loading and in suspect mode. I tr
y
to use command restore database policy with recovery, then got
errorimmediately:
File 'changept' was only partially restored by a database or file restore.
The entire file must be successfully restored before applying the log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I did restore this database two weeks ago in other database server and was
successful, but it is failed in this new server now. I don't know what reaso
n
is. I need the help. Thank in advance.Hi
"Iter" wrote:

> Hi Guys,
> I got an error when I restored database. I tryed to restore a database tha
t
> is 8G. I got an error that is "An internal consistency error occured. Cont
act
> technical support for assistance. RESTORE DATABASE is terminating
> abnormally", then the database was marked Loading and in suspect mode. I
try
> to use command restore database policy with recovery, then got
> errorimmediately:
> File 'changept' was only partially restored by a database or file restore.
> The entire file must be successfully restored before applying the log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I did restore this database two weeks ago in other database server and was
> successful, but it is failed in this new server now. I don't know what rea
son
> is. I need the help. Thank in advance.
Have you copied the backup onto this server? The backup itself may be
corrupted try doing a RESTORE HEADERONLY command from query analyser. It is
not clear how you are restoring this file, try using query analyser to
restore the database if you are using EM then you can post the command you
are using. As this is a new server, the database does not need to exist
before you restore it. Are you putting the files in a different location?
Check that you have permissions and enough space to do this.
If the database exists on a different server you may want to either detach
the database and copy the MDF/LDF files and re-attach them (to both servers!
)
or backup from one server to the other using a UNC path for the backup file,
so that you don't have to copy the backup file.
HTH
John|||>I try to use command restore database policy with recovery, then got
> errorimmediately:
> File 'changept' was only partially restored by a database or file restore.
> The entire file must be successfully restored before applying the log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I did restore this database two weeks ago in other database server and was
> successful, but it is failed in this new server now. I don't know what rea
son
> is. I need the help. Thank in advance.
Can we assume that this is the actual same backup file you are talking about
having restored before? This looks like there may be multiple backups in thi
s
file and it is trying to restore a log file backup before restoring the full
backup.