restore sql 2000 backup.bak to sql 2005 database fail

Under normal conditions, you can restore a SQL Server 2000 (80) database
backup on a SQL Server 2005 instance. However you can't restore a SQL Server
2005 (90) database on a SQL Server 2000 instance.

Can you tell us what error message you get or define what problem you meet?

--
Ekrem Önsoy



"Ken" wrote in message
news:eUld%23Z2zIHA.5472-at-TK2MSFTNGP06.phx.gbl...
> Any one konw the step how to restore sql 2000 database to sql 2005
> i got error when i restore backup.bak(backup from sql 2000) file to sql
> 2005
>
> i right click then choose task , restore
>

Any one konw the step how to restore sql 2000 database to sql 2005
i got error when i restore backup.bak(backup from sql 2000) file to sql 2005

i right click then choose task , restore

Restore fial for server 'shareserver'. (Microsoft.SqlServer.Smo)

Additional information:
an exception occured while execting a Transact-SQL statement or batch
(Microsoft SQL Server, Error: 3154)




"Ekrem Önsoy" wrote in message
news:9534B657-6BDC-47A1-85B9-FA8EE7A25C7C-at-microsoft.com...
> Under normal conditions, you can restore a SQL Server 2000 (80) database
> backup on a SQL Server 2005 instance. However you can't restore a SQL
> Server 2005 (90) database on a SQL Server 2000 instance.
>
> Can you tell us what error message you get or define what problem you
> meet?
>
> --
> Ekrem Önsoy
>
>
>
> "Ken" wrote in message
> news:eUld%23Z2zIHA.5472-at-TK2MSFTNGP06.phx.gbl...
>> Any one konw the step how to restore sql 2000 database to sql 2005
>> i got error when i restore backup.bak(backup from sql 2000) file to sql
>> 2005
>>
>> i right click then choose task , restore
>>
>

The message does not tell much, however you can find some solutions when you
Google the Error code:
http://forums.microsoft.com/MSDN/Sho...94642&SiteID=1

Check that link out if it fits your situation or not.

--
Ekrem Önsoy



"Ken" wrote in message
news:O0ETtx4zIHA.532-at-TK2MSFTNGP06.phx.gbl...
> Restore fial for server 'shareserver'. (Microsoft.SqlServer.Smo)
>
> Additional information:
> an exception occured while execting a Transact-SQL statement or batch
> (Microsoft SQL Server, Error: 3154)
>
>
>
>
> "Ekrem Önsoy" wrote in message
> news:9534B657-6BDC-47A1-85B9-FA8EE7A25C7C-at-microsoft.com...
>> Under normal conditions, you can restore a SQL Server 2000 (80) database
>> backup on a SQL Server 2005 instance. However you can't restore a SQL
>> Server 2005 (90) database on a SQL Server 2000 instance.
>>
>> Can you tell us what error message you get or define what problem you
>> meet?
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "Ken" wrote in message
>> news:eUld%23Z2zIHA.5472-at-TK2MSFTNGP06.phx.gbl...
>>> Any one konw the step how to restore sql 2000 database to sql 2005
>>> i got error when i restore backup.bak(backup from sql 2000) file to sql
>>> 2005
>>>
>>> i right click then choose task , restore
>>>
>>
>
>

The message does not tell much, however you can find some solutions when you
Google the Error code:
http://forums.microsoft.com/MSDN/Sho...94642&SiteID=1

Check that link out if it fits your situation or not.

--
Ekrem Önsoy



"Ken" wrote in message
news:O0ETtx4zIHA.532-at-TK2MSFTNGP06.phx.gbl...
> Restore fial for server 'shareserver'. (Microsoft.SqlServer.Smo)
>
> Additional information:
> an exception occured while execting a Transact-SQL statement or batch
> (Microsoft SQL Server, Error: 3154)
>
>
>
>
> "Ekrem Önsoy" wrote in message
> news:9534B657-6BDC-47A1-85B9-FA8EE7A25C7C-at-microsoft.com...
>> Under normal conditions, you can restore a SQL Server 2000 (80) database
>> backup on a SQL Server 2005 instance. However you can't restore a SQL
>> Server 2005 (90) database on a SQL Server 2000 instance.
>>
>> Can you tell us what error message you get or define what problem you
>> meet?
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "Ken" wrote in message
>> news:eUld%23Z2zIHA.5472-at-TK2MSFTNGP06.phx.gbl...
>>> Any one konw the step how to restore sql 2000 database to sql 2005
>>> i got error when i restore backup.bak(backup from sql 2000) file to sql
>>> 2005
>>>
>>> i right click then choose task , restore
>>>
>>
>
>

Ken (ken-at-yahoo.com.hk) writes:
> Restore fial for server 'shareserver'. (Microsoft.SqlServer.Smo)
>
> Additional information:
> an exception occured while execting a Transact-SQL statement or batch
> (Microsoft SQL Server, Error: 3154)

Rather than pressing OK in the dialog, select the Script option in the
top of dialog, and script to a query window. Then run that query window.
If the error persists, post both the script and the error message,

--
Erland Sommarskog, SQL Server MVP, esquel-at-sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Still restore fail error message is

Restore failed for server 'share' (Microsoft.SqlServer.Smo)

Additional information:
System.data.sqlclient.sqlerror: restore detected an error on page (0:0 in
database "News" as read from the backup set. (Microsoft.sqlserver.smo)


"Erland Sommarskog" wrote in message
news:Xns9AC039178604Yazorman-at-127.0.0.1...
> Ken (ken-at-yahoo.com.hk) writes:
>> Restore fial for server 'shareserver'. (Microsoft.SqlServer.Smo)
>>
>> Additional information:
>> an exception occured while execting a Transact-SQL statement or batch
>> (Microsoft SQL Server, Error: 3154)
>
> Rather than pressing OK in the dialog, select the Script option in the
> top of dialog, and script to a query window. Then run that query window.
> If the error persists, post both the script and the error message,
>
> --
> Erland Sommarskog, SQL Server MVP, esquel-at-sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx

It looks like your database backup is corrupted. Try to restore a better
backup instead of this corrupted one if you have any chance.

--
Ekrem Önsoy



"Ken" wrote in message
news:ea90luB0IHA.4816-at-TK2MSFTNGP03.phx.gbl...
> Still restore fail error message is
>
> Restore failed for server 'share' (Microsoft.SqlServer.Smo)
>
> Additional information:
> System.data.sqlclient.sqlerror: restore detected an error on page (0:0
> in database "News" as read from the backup set. (Microsoft.sqlserver.smo)
>
>
> "Erland Sommarskog" wrote in message
> news:Xns9AC039178604Yazorman-at-127.0.0.1...
>> Ken (ken-at-yahoo.com.hk) writes:
>>> Restore fial for server 'shareserver'. (Microsoft.SqlServer.Smo)
>>>
>>> Additional information:
>>> an exception occured while execting a Transact-SQL statement or batch
>>> (Microsoft SQL Server, Error: 3154)
>>
>> Rather than pressing OK in the dialog, select the Script option in the
>> top of dialog, and script to a query window. Then run that query window.
>> If the error persists, post both the script and the error message,
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esquel-at-sommarskog.se
>>
>> Books Online for SQL Server 2005 at
>> http://www.microsoft.com/technet/pro...ads/books.mspx
>> Books Online for SQL Server 2000 at
>> http://www.microsoft.com/sql/prodinf...ons/books.mspx
>
>

Ken (ken-at-yahoo.com.hk) writes:
> Still restore fail error message is
>
> Restore failed for server 'share' (Microsoft.SqlServer.Smo)
>
> Additional information: System.data.sqlclient.sqlerror: restore detected
> an error on page (0:0 in database "News" as read from the backup set.
> (Microsoft.sqlserver.smo)

You forgot to include the RESTORE command. And the output does not look
like it comes from a query window.

But judging from the error message, the backup is either damaged - or it
is not a backup file at all.

--
Erland Sommarskog, SQL Server MVP, esquel-at-sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thank all, the file have problem , i success restore when i backup new file
for restore, many thank

"Erland Sommarskog" wrote in message
news:Xns9AC14681EB3CYazorman-at-127.0.0.1...
> Ken (ken-at-yahoo.com.hk) writes:
>> Still restore fail error message is
>>
>> Restore failed for server 'share' (Microsoft.SqlServer.Smo)
>>
>> Additional information: System.data.sqlclient.sqlerror: restore detected
>> an error on page (0:0 in database "News" as read from the backup set.
>> (Microsoft.sqlserver.smo)
>
> You forgot to include the RESTORE command. And the output does not look
> like it comes from a query window.
>
> But judging from the error message, the backup is either damaged - or it
> is not a backup file at all.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel-at-sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx