Thursday, March 29, 2012

Error restoring sql backup

Hi All,
I was trying to restore a sql server backup in a Windows 2000 Advanced
Server cluster running SQL Server Enterprise Edition Service Pack 3, in two
nodes.
I have restored successfully some databases, buy I can not restore two
databases. I have obtained the error bellow:
Error 3241 Severity 16 State 1
The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
SQL Server cannot process this media family.
I have tried the Microsoft Article Q297104, but the error continues.
Can anybody help me?
Thanks in advance,
Guillermo Roldan
Spain
Hi
I am not sure what is happening here, but if the KB article is not working,
and you have used the trace flag correctly, then you may want to try some of
the following:
viewing the header only,
restoring the backup onto a different machine,
check the cluster resources allow access to this drive and the files
destination of the MDF and LDF are available.
John
"Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
> Hi All,
> I was trying to restore a sql server backup in a Windows 2000 Advanced
> Server cluster running SQL Server Enterprise Edition Service Pack 3, in
> two
> nodes.
> I have restored successfully some databases, buy I can not restore two
> databases. I have obtained the error bellow:
> Error 3241 Severity 16 State 1
> The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> I have tried the Microsoft Article Q297104, but the error continues.
> Can anybody help me?
> Thanks in advance,
> Guillermo Roldan
> Spain
>
|||Hi John,
I have tried to execute RESTORE HEADERONLY, resulting in an ***INCOMPLETE***
message. I do not understand, because I have checked maintenance plan every
day, and backups was OK. Now, there are only two backups, and there are
incomplete.
It is possible to recover an incomplete backup? There is a full database
backup, with no transactional log backups.
I would like to try the MSSQLRecovery tool on Monday…
Thanks for your answer, John
Guillermo Roldan
Spain
"John Bell" escribió:

> Hi
> I am not sure what is happening here, but if the KB article is not working,
> and you have used the trace flag correctly, then you may want to try some of
> the following:
> viewing the header only,
> restoring the backup onto a different machine,
> check the cluster resources allow access to this drive and the files
> destination of the MDF and LDF are available.
> John
> "Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
> message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
>
>
|||Hi
I can only think that it may be disc corruption, although I would have
expected you to have other things to indicate such a failure. If you
have a backup elsewhere you may want to try that, if not a call to PSS
may required.
John
|||Hi John,
I have discover why it is an Incomplete backup. The tape-robot was offline
since 22/11/2005 because a hardware problem, so somebody copy the sql server
backup files to a Novell Netware share. This is the problem: This Novell
Netware share has a limit of 4.194.304 KB. But the real backup was about
8,5GB !!
Finally, i can restore a new backup from tape. This new backup it's older
(18/11/2005), but it run sucesfully !
Thanks John, for your answers
Guillermo Roldan
"John Bell" wrote:

> Hi
> I can only think that it may be disc corruption, although I would have
> expected you to have other things to indicate such a failure. If you
> have a backup elsewhere you may want to try that, if not a call to PSS
> may required.
> John
>
sql

Error restoring sql backup

Hi All,
I was trying to restore a sql server backup in a Windows 2000 Advanced
Server cluster running SQL Server Enterprise Edition Service Pack 3, in two
nodes.
I have restored successfully some databases, buy I can not restore two
databases. I have obtained the error bellow:
Error 3241 Severity 16 State 1
The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
SQL Server cannot process this media family.
I have tried the Microsoft Article Q297104, but the error continues.
Can anybody help me?
Thanks in advance,
Guillermo Roldan
SpainHi
I am not sure what is happening here, but if the KB article is not working,
and you have used the trace flag correctly, then you may want to try some of
the following:
viewing the header only,
restoring the backup onto a different machine,
check the cluster resources allow access to this drive and the files
destination of the MDF and LDF are available.
John
"Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
> Hi All,
> I was trying to restore a sql server backup in a Windows 2000 Advanced
> Server cluster running SQL Server Enterprise Edition Service Pack 3, in
> two
> nodes.
> I have restored successfully some databases, buy I can not restore two
> databases. I have obtained the error bellow:
> Error 3241 Severity 16 State 1
> The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> I have tried the Microsoft Article Q297104, but the error continues.
> Can anybody help me?
> Thanks in advance,
> Guillermo Roldan
> Spain
>|||Hi John,
I have tried to execute RESTORE HEADERONLY, resulting in an ***INCOMPLETE***
message. I do not understand, because I have checked maintenance plan every
day, and backups was OK. Now, there are only two backups, and there are
incomplete.
It is possible to recover an incomplete backup? There is a full database
backup, with no transactional log backups.
I would like to try the MSSQLRecovery tool on Mondayâ?¦
Thanks for your answer, John
Guillermo Roldan
Spain
"John Bell" escribió:
> Hi
> I am not sure what is happening here, but if the KB article is not working,
> and you have used the trace flag correctly, then you may want to try some of
> the following:
> viewing the header only,
> restoring the backup onto a different machine,
> check the cluster resources allow access to this drive and the files
> destination of the MDF and LDF are available.
> John
> "Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
> message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
> > Hi All,
> >
> > I was trying to restore a sql server backup in a Windows 2000 Advanced
> > Server cluster running SQL Server Enterprise Edition Service Pack 3, in
> > two
> > nodes.
> >
> > I have restored successfully some databases, buy I can not restore two
> > databases. I have obtained the error bellow:
> >
> > Error 3241 Severity 16 State 1
> > The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
> > SQL Server cannot process this media family.
> >
> > I have tried the Microsoft Article Q297104, but the error continues.
> >
> > Can anybody help me?
> >
> > Thanks in advance,
> > Guillermo Roldan
> > Spain
> >
>
>|||Hi
I can only think that it may be disc corruption, although I would have
expected you to have other things to indicate such a failure. If you
have a backup elsewhere you may want to try that, if not a call to PSS
may required.
John|||Hi John,
I have discover why it is an Incomplete backup. The tape-robot was offline
since 22/11/2005 because a hardware problem, so somebody copy the sql server
backup files to a Novell Netware share. This is the problem: This Novell
Netware share has a limit of 4.194.304 KB. But the real backup was about
8,5GB !!
Finally, i can restore a new backup from tape. This new backup it's older
(18/11/2005), but it run sucesfully !
Thanks John, for your answers
Guillermo Roldan
"John Bell" wrote:
> Hi
> I can only think that it may be disc corruption, although I would have
> expected you to have other things to indicate such a failure. If you
> have a backup elsewhere you may want to try that, if not a call to PSS
> may required.
> John
>

Error restoring sql backup

Hi All,
I was trying to restore a sql server backup in a Windows 2000 Advanced
Server cluster running SQL Server Enterprise Edition Service Pack 3, in two
nodes.
I have restored successfully some databases, buy I can not restore two
databases. I have obtained the error bellow:
Error 3241 Severity 16 State 1
The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
SQL Server cannot process this media family.
I have tried the Microsoft Article Q297104, but the error continues.
Can anybody help me?
Thanks in advance,
Guillermo Roldan
SpainHi
I am not sure what is happening here, but if the KB article is not working,
and you have used the trace flag correctly, then you may want to try some of
the following:
viewing the header only,
restoring the backup onto a different machine,
check the cluster resources allow access to this drive and the files
destination of the MDF and LDF are available.
John
"Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
> Hi All,
> I was trying to restore a sql server backup in a Windows 2000 Advanced
> Server cluster running SQL Server Enterprise Edition Service Pack 3, in
> two
> nodes.
> I have restored successfully some databases, buy I can not restore two
> databases. I have obtained the error bellow:
> Error 3241 Severity 16 State 1
> The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> I have tried the Microsoft Article Q297104, but the error continues.
> Can anybody help me?
> Thanks in advance,
> Guillermo Roldan
> Spain
>|||Hi John,
I have tried to execute RESTORE HEADERONLY, resulting in an ***INCOMPLETE***
message. I do not understand, because I have checked maintenance plan every
day, and backups was OK. Now, there are only two backups, and there are
incomplete.
It is possible to recover an incomplete backup? There is a full database
backup, with no transactional log backups.
I would like to try the MSSQLRecovery tool on Monday…
Thanks for your answer, John
Guillermo Roldan
Spain
"John Bell" escribió:

> Hi
> I am not sure what is happening here, but if the KB article is not working
,
> and you have used the trace flag correctly, then you may want to try some
of
> the following:
> viewing the header only,
> restoring the backup onto a different machine,
> check the cluster resources allow access to this drive and the files
> destination of the MDF and LDF are available.
> John
> "Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
> message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
>
>|||Hi
I can only think that it may be disc corruption, although I would have
expected you to have other things to indicate such a failure. If you
have a backup elsewhere you may want to try that, if not a call to PSS
may required.
John|||Hi John,
I have discover why it is an Incomplete backup. The tape-robot was offline
since 22/11/2005 because a hardware problem, so somebody copy the sql server
backup files to a Novell Netware share. This is the problem: This Novell
Netware share has a limit of 4.194.304 KB. But the real backup was about
8,5GB !!
Finally, i can restore a new backup from tape. This new backup it's older
(18/11/2005), but it run sucesfully !
Thanks John, for your answers
Guillermo Roldan
"John Bell" wrote:

> Hi
> I can only think that it may be disc corruption, although I would have
> expected you to have other things to indicate such a failure. If you
> have a backup elsewhere you may want to try that, if not a call to PSS
> may required.
> John
>

Error restoring MSDB database

I'm getting the following error while trying to restore the msdb database:
The backup of the system database on device
d:\mssql\backup\msdb_db_200510312200.BAK
cannot be restored because it was created by a different version of the
server (134218488) than this server (134218546).
Both servers are SQL2000 SE.
Ron
Ron wrote:
> I'm getting the following error while trying to restore the msdb
> database:
> The backup of the system database on device
> d:\mssql\backup\msdb_db_200510312200.BAK
> cannot be restored because it was created by a different version of
> the server (134218488) than this server (134218546).
> Both servers are SQL2000 SE.
> Ron
The backup is from a server with an older service pack than the one you
are restoring to. Make sure they are both the same service pack.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Can you tell from the version from the number - (134218488)?
"David Gugick" wrote:

> Ron wrote:
> The backup is from a server with an older service pack than the one you
> are restoring to. Make sure they are both the same service pack.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||Ron wrote:
> Can you tell from the version from the number - (134218488)?
>
I think that is SP3/SP3a, but read the following links for info on how
to get the version and a possible way to restore the msdb.
http://www.developmentnow.com/g/118_...the-server.htm
http://www.sqlservercentral.com/foru...ssageid=229354
David Gugick
Quest Software
www.imceda.com
www.quest.com

Error restoring MSDB database

I'm getting the following error while trying to restore the msdb database:
The backup of the system database on device
d:\mssql\backup\msdb_db_200510312200.BAK
cannot be restored because it was created by a different version of the
server (134218488) than this server (134218546).
Both servers are SQL2000 SE.
RonRon wrote:
> I'm getting the following error while trying to restore the msdb
> database:
> The backup of the system database on device
> d:\mssql\backup\msdb_db_200510312200.BAK
> cannot be restored because it was created by a different version of
> the server (134218488) than this server (134218546).
> Both servers are SQL2000 SE.
> Ron
The backup is from a server with an older service pack than the one you
are restoring to. Make sure they are both the same service pack.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Can you tell from the version from the number - (134218488)?
"David Gugick" wrote:

> Ron wrote:
> The backup is from a server with an older service pack than the one you
> are restoring to. Make sure they are both the same service pack.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||Ron wrote:
> Can you tell from the version from the number - (134218488)?
>
I think that is SP3/SP3a, but read the following links for info on how
to get the version and a possible way to restore the msdb.
http://www.developmentnow.com/g/118...-the-server.htm
http://www.sqlservercentral.com/for...=229354

David Gugick
Quest Software
www.imceda.com
www.quest.com

Error restoring MSDB database

I'm getting the following error while trying to restore the msdb database:
The backup of the system database on device
d:\mssql\backup\msdb_db_200510312200.BAK
cannot be restored because it was created by a different version of the
server (134218488) than this server (134218546).
Both servers are SQL2000 SE.
RonRon wrote:
> I'm getting the following error while trying to restore the msdb
> database:
> The backup of the system database on device
> d:\mssql\backup\msdb_db_200510312200.BAK
> cannot be restored because it was created by a different version of
> the server (134218488) than this server (134218546).
> Both servers are SQL2000 SE.
> Ron
The backup is from a server with an older service pack than the one you
are restoring to. Make sure they are both the same service pack.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Can you tell from the version from the number - (134218488)?
"David Gugick" wrote:
> Ron wrote:
> > I'm getting the following error while trying to restore the msdb
> > database:
> >
> > The backup of the system database on device
> > d:\mssql\backup\msdb_db_200510312200.BAK
> > cannot be restored because it was created by a different version of
> > the server (134218488) than this server (134218546).
> >
> > Both servers are SQL2000 SE.
> >
> > Ron
> The backup is from a server with an older service pack than the one you
> are restoring to. Make sure they are both the same service pack.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||Ron wrote:
> Can you tell from the version from the number - (134218488)?
>
I think that is SP3/SP3a, but read the following links for info on how
to get the version and a possible way to restore the msdb.
http://www.developmentnow.com/g/118_2003_11_0_0_464983/Restore-error--different-version-of-the-server.htm
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=229354
David Gugick
Quest Software
www.imceda.com
www.quest.comsql

Error restoring from SQL 2000 to 2005

Hi all,

I'm having problem to restore DB from SQL server 2000 to 2005.
Here is the error:

Restore failed for 'PROD'. (Micrsoft.SqlServer.Smo)
System.data.sqlclient.sqlerror:Invalid colun name'SC_BL_ADAPT'.(MicrsoftSQLSever.Smo).

Thanks for any help.

Regards,

Abrahim

__

check whether the backup is taken properly or not

RESTORE VERIFYONLY : To varify the database backup integrity

RESTORE FILELISTONLY : see the contents of backup file

Read more about these in BOL

Madhu

|||

Madhu,

The database has been backed-up with “Verify backup upon completion” on SQL server 2000.
I have no problem to restore the database in SQL 2000. It just SQL 2005 is not happy with column name “SC_BL_ADAPT”.

Any idea about “SC_BL_ADAPT”?

I’ll look it to RESTORE VERIFYONLY : To varify the database backup integrity

RESTORE FILELISTONLY : see the contents of backup file

Thanks in advance,

Abrahim

|||

sql server 2000 Restore Verifyonly is a useless command. it only check the header. But in SQL Server 2005 Restore varifyonly check the physical file integrity. check in 2005. And also try to restore this backup file in sql server 2000 as a temp database (only for the sake of error finding) and post back the result

Madhu

|||

Check the sql error log...if there is any other error related to restore.

|||

I think this is a tools problem and may not be the backup, try restoring using Query editior or have you tried?

Have you tested this from another machine?

|||Here is what I have done so far:
RESTORE verifyonly from disk =
N'C:\capdb_to_2005_1.bak'

Messages:
The backup set is valid.

/////////////////////////
then:
RESTORE FILELISTONLY from disk =
N'C:\capdb_to_2005_1.bak'

messages:
(4 row(s) affected)

Results:

capdb_Data C:\capdb_Data.MDF D PRIMARY 524288000 35184372080640
capdb_1_Data C:\capdb_1_Data D PRIMARY 1048576 35184372080640
capdb_Log C:\capdb_Log.LDF L NULL 1048576 35184372080640
capdb_1_Log C:\capdb_1_Log L NULL 13959168 35184372080640
/////////////////////////////////////////////

Yes, I try to restore it from several systems, but still have problem.|||You got the File List successfully, now have you actually tried a RESTORE DATABASE command?