Db Restore Problems

Hi All,
i have backed up a database from SQL server 7.0 on a file.
now when i try to restore the same backup on other machine
it gives me the following error.
Microsoft SQL-DMO (ODBC SQLState: 42000)
The file on device is not a valid Microsoft Tape format backup set
pls could some1 help me out with this problem asap.
Thx
--
KNIGH
----
KNIGHT's Profile: http://www.msusenet.com/member.php?userid=95
View this thread: http://www.msusenet.com/t-187040395You could try RESTORE HEADERONLY and RESTORE FILELISTONLY and see if those also give you the same
error. If they do, and you are certain that you got the syntax right, I suggest you open a support
case with MS (as this seems to in need for a quick solution).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KNIGHT" <KNIGHT.1oi0wb@.no-mx.msusenet.com> wrote in message
news:KNIGHT.1oi0wb@.no-mx.msusenet.com...
> Hi All,
> i have backed up a database from SQL server 7.0 on a file.
> now when i try to restore the same backup on other machine
> it gives me the following error.
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> The file on device is not a valid Microsoft Tape format backup set
> pls could some1 help me out with this problem asap.
> Thx.
>
> --
> KNIGHT
> ---
> KNIGHT's Profile: http://www.msusenet.com/member.php?userid=951
> View this thread: http://www.msusenet.com/t-1870403952
>|||hi, thx for the reply,
i tried the restore command you provided and following is the output o
the same.
NULL NULL 1 NULL 0 1 2 sa HOME POS 515 2004-08-2
19:49:58.000 2556928 98000000015100001 98000000015300001 98000000015100001 67000000040300001 2005-05-0
21:39:49.000 NULL 146 9 1033 196609 70 4608 7 0 623 HOME 0 {DDBB3598-43BE-44B9-9B23-B51895A59011} NULL NULL
POS_Data C:\MSSQL7\data\POS_Data.MDF D PRIMARY 2555904 35184372080640
POS_Log C:\MSSQL7\data\POS_Log.LDF L NULL 1048576 35184372080640
what should be done next and what does this log represent, is my dat
ok
--
KNIGH
----
KNIGHT's Profile: http://www.msusenet.com/member.php?userid=95
View this thread: http://www.msusenet.com/t-187040395|||Looking good so far (but you didn't post the RESTORE commands you executed). Now try doing the
actual RESTORE from Query Analyzer. Again, please post the command you executed and the exact error
messages from SQL Server. Another thing you can try is RESTORE VERIFYONLY.
To understand the result of these commands, just read about them in Books Online. They are
documented.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KNIGHT" <KNIGHT.1oic0c@.no-mx.msusenet.com> wrote in message
news:KNIGHT.1oic0c@.no-mx.msusenet.com...
> hi, thx for the reply,
> i tried the restore command you provided and following is the output of
> the same.
> NULL NULL 1 NULL 0 1 2 sa HOME POS 515 2004-08-23
> 19:49:58.000 2556928 98000000015100001 98000000015300001 98000000015100001 67000000040300001
> 2005-05-02
> 21:39:49.000 NULL 146 9 1033 196609 70 4608 7 0 623 HOME 0 {DDBB3598-43BE-44B9-9B23-B51895A59011}
> NULL NULL
>
> POS_Data C:\MSSQL7\data\POS_Data.MDF D PRIMARY 2555904 35184372080640
> POS_Log C:\MSSQL7\data\POS_Log.LDF L NULL 1048576 35184372080640
>
> what should be done next and what does this log represent, is my data
> ok.
>
> --
> KNIGHT
> ---
> KNIGHT's Profile: http://www.msusenet.com/member.php?userid=951
> View this thread: http://www.msusenet.com/t-1870403952
>|||following is the message from the QA, when i try RESTORE and RESTOR
VERIFYONLY as you suggested.
Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'c:\pos.bak' is not a valid Microsoft Tape Forma
backup set.
Server: Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally
--
KNIGH
----
KNIGHT's Profile: http://www.msusenet.com/member.php?userid=95
View this thread: http://www.msusenet.com/t-187040395|||Then you might just have a corrupt backup. I suggest you open a case with MS Support and see if they
can assist in any way.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KNIGHT" <KNIGHT.1oikch@.no-mx.msusenet.com> wrote in message
news:KNIGHT.1oikch@.no-mx.msusenet.com...
> following is the message from the QA, when i try RESTORE and RESTORE
> VERIFYONLY as you suggested.
> Server: Msg 3242, Level 16, State 2, Line 1
> The file on device 'c:\pos.bak' is not a valid Microsoft Tape Format
> backup set.
> Server: Msg 3013, Level 16, State 1, Line 1
> VERIFY DATABASE is terminating abnormally.
>
> --
> KNIGHT
> ---
> KNIGHT's Profile: http://www.msusenet.com/member.php?userid=951
> View this thread: http://www.msusenet.com/t-1870403952
>