dbTalk Databases Forums  

restore sql 2000 backup.bak to sql 2005 database fail

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools restore sql 2000 backup.bak to sql 2005 database fail

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss restore sql 2000 backup.bak to sql 2005 database fail in the microsoft.public.sqlserver.tools forum.



Reply
Page 5 of 10 < 1 2 3 4 5 6 7 8 9 10 >
 
Thread Tools Display Modes
  #41  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 05:20 PM





Ken (ken (AT) yahoo (DOT) com.hk) writes:
Quote:
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 (DOT) 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


Reply With Quote
  #42  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 05:20 PM





Ken (ken (AT) yahoo (DOT) com.hk) writes:
Quote:
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 (DOT) 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


Reply With Quote
  #43  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 05:20 PM


Ken (ken (AT) yahoo (DOT) com.hk) writes:
Quote:
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 (DOT) 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


Reply With Quote
  #44  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 05:20 PM


Ken (ken (AT) yahoo (DOT) com.hk) writes:
Quote:
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 (DOT) 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


Reply With Quote
  #45  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 05:20 PM


Ken (ken (AT) yahoo (DOT) com.hk) writes:
Quote:
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 (DOT) 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


Reply With Quote
  #46  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 05:20 PM


Ken (ken (AT) yahoo (DOT) com.hk) writes:
Quote:
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 (DOT) 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


Reply With Quote
  #47  
Old   
Ken
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 08:44 PM


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" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ken (ken (AT) yahoo (DOT) 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 (DOT) 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



Reply With Quote
  #48  
Old   
Ken
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 08:44 PM


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" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ken (ken (AT) yahoo (DOT) 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 (DOT) 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



Reply With Quote
  #49  
Old   
Ken
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 08:44 PM


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" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ken (ken (AT) yahoo (DOT) 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 (DOT) 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



Reply With Quote
  #50  
Old   
Ken
 
Posts: n/a

Default Re: restore sql 2000 backup.bak to sql 2005 database fail - 06-16-2008 , 08:44 PM


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" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Ken (ken (AT) yahoo (DOT) 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 (DOT) 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



Reply With Quote
Reply
Page 5 of 10 < 1 2 3 4 5 6 7 8 9 10 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top