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.
KNIGHT
---
KNIGHT's Profile: http://www.msmcse.ms/member.php?userid=951
View this thread: http://www.msmcse.ms/t-1870403952You could try RESTORE HEADERONLY and RESTORE FILELISTONLY and see if those a
lso give you the same
error. If they do, and you are certain that you got the syntax right, I sugg
est 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.msmcse.ms> wrote in message
news:KNIGHT.1oi0wb@.no-mx.msmcse.ms...
> 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.msmcse.ms/member.php?userid=951
> View this thread: http://www.msmcse.ms/t-1870403952
>|||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 2
004-08-23
19:49:58. 000 2556928 98000000015100001 9800000001
5300001 98000000015100001 6
7000000040300001 2005-05-02
21:39:49. 000 NULL 146 9 1033 196609 70 4608 7 0 6
23 HOME 0 {DDBB3598-43
BE-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.msmcse.ms/member.php?userid=951
View this thread: http://www.msmcse.ms/t-1870403952|||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 execu
ted 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 On
line. They are
documented.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KNIGHT" <KNIGHT.1oic0c@.no-mx.msmcse.ms> wrote in message
news:KNIGHT.1oic0c@.no-mx.msmcse.ms...
> 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.msmcse.ms/member.php?userid=951
> View this thread: http://www.msmcse.ms/t-1870403952
>|||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.msmcse.ms/member.php?userid=951
View this thread: http://www.msmcse.ms/t-1870403952|||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.msmcse.ms> wrote in message
news:KNIGHT.1oikch@.no-mx.msmcse.ms...
> 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.msmcse.ms/member.php?userid=951
> View this thread: http://www.msmcse.ms/t-1870403952
>