Backup and restore

Hi,
When I tried to restore a database backup that was created by SQL Server
2000 / SP3a installation into a SQL Server 2000 / SP4, I got the following
error message -
Microsoft SQL-DMO (ODBC SQLState: 42000)
The file on device 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\<DATABASE_NAME>.dbk' is not a valid Microsoft Tape Format
backup set.
RESTORE DATABASE is terminating abnormally.
OK
Hence my following queries -
1) Can I restore a backup
MBS Axapta - MVP
http://www.harishm.com/
Somehow I must have pressed the 'enter' key before writing my earlier post!!
Here are my actual queries -
1) Can I backup/restore from SQL servers with different SPs?
2) If I can, could someone please tell me what the error is all about? Apart
from the SP difference, both systems are identical in all aspects including
network protocols (TCP/IP).
Many thanks in advance,
Harish Mohanbabu
MBS Axapta - MVP
http://www.harishm.com/
"Harish Mohanbabu" wrote:
> Hi,
> When I tried to restore a database backup that was created by SQL Server
> 2000 / SP3a installation into a SQL Server 2000 / SP4, I got the following
> error message -
> --
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> --
> The file on device 'D:\Program Files\Microsoft SQL
> Server\MSSQL\Data\<DATABASE_NAME>.dbk' is not a valid Microsoft Tape Format
> backup set.
> RESTORE DATABASE is terminating abnormally.
> --
> OK
> --
> Hence my following queries -
> 1) Can I restore a backup
|||could you try running restore filelistonly and restore headeronly...
and could you post the output...

>From my initial toughts, it looks like your bkup is corrupt.. cant be
sure yet..
|||Hi,
There shall not be problem to restore user databases between different SPs.
It is more like backup corruption. You may want to try to install a test
machine with SP3a to make sure it is not the cause of the problem. Or, you
may try to restore to other sql server to test.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Shadow" <dinu_babu@.yahoo.com>
>Newsgroups: microsoft.public.sqlserver.server
>Subject: Re: Backup and restore
>Date: 1 Feb 2006 04:58:37 -0800
>Organization: http://groups.google.com
>Lines: 6
>Message-ID: <1138798716.749411.122180@.g43g2000cwa.googlegroups .com>
>References: <A9767E10-89BD-44BE-805F-06DBDFEE7FA2@.microsoft.com>
> <376FB79B-EC2D-4520-A7B8-F20D4A3CEBC9@.microsoft.com>
>NNTP-Posting-Host: 207.46.50.70
>Mime-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-1"
>X-Trace: posting.google.com 1138798722 18121 127.0.0.1 (1 Feb 2006
12:58:42 GMT)
>X-Complaints-To: groups-abuse@.google.com
>NNTP-Posting-Date: Wed, 1 Feb 2006 12:58:42 +0000 (UTC)
>In-Reply-To: <376FB79B-EC2D-4520-A7B8-F20D4A3CEBC9@.microsoft.com>
>User-Agent: G2/0.2
>X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)
>X-HTTP-Via: 1.0 APS-PRXY-01
>Complaints-To: groups-abuse@.google.com
>Injection-Info: g43g2000cwa.googlegroups.com; posting-host=207.46.50.70;
> posting-account=kL0mBg0AAABi9x5I5akt-eVvS_W0s-_U
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfee d00.sul.t-online.de!t-onli
ne.de!news.glorb.com!postnews.google.com!g43g2000c wa.googlegroups.com!not-fo
r-mail
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419694
>X-Tomcat-NG: microsoft.public.sqlserver.server
>could you try running restore filelistonly and restore headeronly...
>and could you post the output...
>sure yet..
>
|||Thanks for your posts :-)
You are right Peter - the backup was corrupted. Copied it once again and it
works like a charm!
Cheers,
Harish Mohanbabu
MBS Axapta - MVP
http://www.harishm.com/
"Peter Yang [MSFT]" wrote:

> Hi,
> There shall not be problem to restore user databases between different SPs.
> It is more like backup corruption. You may want to try to install a test
> machine with SP3a to make sure it is not the cause of the problem. Or, you
> may try to restore to other sql server to test.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
|||Hello Harish,
Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Backup and restore
>thread-index: AcYoIJrluIUoFfrTQRWeqgnU3F5b4w==
>X-WBNR-Posting-Host: 217.15.170.246
>From: "=?Utf-8?B?SGFyaXNoIE1vaGFuYmFidQ==?=" <Axapta@.online.nospam>
>References: <A9767E10-89BD-44BE-805F-06DBDFEE7FA2@.microsoft.com>
<376FB79B-EC2D-4520-A7B8-F20D4A3CEBC9@.microsoft.com>
<1138798716.749411.122180@.g43g2000cwa.googlegroups .com>
<TbHbgt5JGHA.3152@.TK2MSFTNGXA02.phx.gbl>
>Subject: Re: Backup and restore
>Date: Thu, 2 Feb 2006 09:46:32 -0800
>Lines: 30
>Message-ID: <BCC389C0-3828-4BED-B7EA-4DED3B7B6CFC@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419873
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Thanks for your posts :-)
>You are right Peter - the backup was corrupted. Copied it once again and
it[vbcol=seagreen]
>works like a charm!
>Cheers,
>Harish Mohanbabu
>--
>MBS Axapta - MVP
>http://www.harishm.com/
>"Peter Yang [MSFT]" wrote:
SPs.[vbcol=seagreen]
you
>