 | |
backup always fails on restore
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: backup always fails on restore -
09-27-2008
, 03:54 PM
|
SQL Server 2005 Developer Edition for all boxes. I have a small database on a W03S x64 box. I perform a backup using SSMS. No errors. I copy the .bak file ( ~ 0.5 gb ) to an XP machine and use SSMS to restore it. I receive the error : Restore failed for Server 'localhost'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:1194741) in database "MyDb" as read from the backup set. (Microsoft.SqlServer.Smo) I repeat the process and receive the same error. |
where you took the backup. If that fails, the problem is in the areas
that Russell discusses:
1) The database is corrupt.
2) The backup is bad.
3) The disk to which you write the backup is bad.
You could narrow this down by backing up the database to another disk.
If the backup on the source server succeeds, then you are presumably
victim to some network problem which corrupts the database when you
copy it. (Or you have a hardware problem on the machine that performs
the copy.)
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#22
| |||
| |||
|
|
SQL Server 2005 Developer Edition for all boxes. I have a small database on a W03S x64 box. I perform a backup using SSMS. No errors. I copy the .bak file ( ~ 0.5 gb ) to an XP machine and use SSMS to restore it. I receive the error : Restore failed for Server 'localhost'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:1194741) in database "MyDb" as read from the backup set. (Microsoft.SqlServer.Smo) I repeat the process and receive the same error. |
where you took the backup. If that fails, the problem is in the areas
that Russell discusses:
1) The database is corrupt.
2) The backup is bad.
3) The disk to which you write the backup is bad.
You could narrow this down by backing up the database to another disk.
If the backup on the source server succeeds, then you are presumably
victim to some network problem which corrupts the database when you
copy it. (Or you have a hardware problem on the machine that performs
the copy.)
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#23
| |||
| |||
|
|
SQL Server 2005 Developer Edition for all boxes. I have a small database on a W03S x64 box. I perform a backup using SSMS. No errors. I copy the .bak file ( ~ 0.5 gb ) to an XP machine and use SSMS to restore it. I receive the error : Restore failed for Server 'localhost'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:1194741) in database "MyDb" as read from the backup set. (Microsoft.SqlServer.Smo) I repeat the process and receive the same error. |
where you took the backup. If that fails, the problem is in the areas
that Russell discusses:
1) The database is corrupt.
2) The backup is bad.
3) The disk to which you write the backup is bad.
You could narrow this down by backing up the database to another disk.
If the backup on the source server succeeds, then you are presumably
victim to some network problem which corrupts the database when you
copy it. (Or you have a hardware problem on the machine that performs
the copy.)
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#24
| |||
| |||
|
|
SQL Server 2005 Developer Edition for all boxes. I have a small database on a W03S x64 box. I perform a backup using SSMS. No errors. I copy the .bak file ( ~ 0.5 gb ) to an XP machine and use SSMS to restore it. I receive the error : Restore failed for Server 'localhost'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:1194741) in database "MyDb" as read from the backup set. (Microsoft.SqlServer.Smo) I repeat the process and receive the same error. |
where you took the backup. If that fails, the problem is in the areas
that Russell discusses:
1) The database is corrupt.
2) The backup is bad.
3) The disk to which you write the backup is bad.
You could narrow this down by backing up the database to another disk.
If the backup on the source server succeeds, then you are presumably
victim to some network problem which corrupts the database when you
copy it. (Or you have a hardware problem on the machine that performs
the copy.)
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#25
| |||
| |||
|
|
SQL Server 2005 Developer Edition for all boxes. I have a small database on a W03S x64 box. I perform a backup using SSMS. No errors. I copy the .bak file ( ~ 0.5 gb ) to an XP machine and use SSMS to restore it. I receive the error : Restore failed for Server 'localhost'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:1194741) in database "MyDb" as read from the backup set. (Microsoft.SqlServer.Smo) I repeat the process and receive the same error. |
where you took the backup. If that fails, the problem is in the areas
that Russell discusses:
1) The database is corrupt.
2) The backup is bad.
3) The disk to which you write the backup is bad.
You could narrow this down by backing up the database to another disk.
If the backup on the source server succeeds, then you are presumably
victim to some network problem which corrupts the database when you
copy it. (Or you have a hardware problem on the machine that performs
the copy.)
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#26
| |||
| |||
|
|
SQL Server 2005 Developer Edition for all boxes. I have a small database on a W03S x64 box. I perform a backup using SSMS. No errors. I copy the .bak file ( ~ 0.5 gb ) to an XP machine and use SSMS to restore it. I receive the error : Restore failed for Server 'localhost'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:1194741) in database "MyDb" as read from the backup set. (Microsoft.SqlServer.Smo) I repeat the process and receive the same error. |
where you took the backup. If that fails, the problem is in the areas
that Russell discusses:
1) The database is corrupt.
2) The backup is bad.
3) The disk to which you write the backup is bad.
You could narrow this down by backing up the database to another disk.
If the backup on the source server succeeds, then you are presumably
victim to some network problem which corrupts the database when you
copy it. (Or you have a hardware problem on the machine that performs
the copy.)
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#27
| |||
| |||
|
|
SQL Server 2005 Developer Edition for all boxes. I have a small database on a W03S x64 box. I perform a backup using SSMS. No errors. I copy the .bak file ( ~ 0.5 gb ) to an XP machine and use SSMS to restore it. I receive the error : Restore failed for Server 'localhost'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:1194741) in database "MyDb" as read from the backup set. (Microsoft.SqlServer.Smo) I repeat the process and receive the same error. |
where you took the backup. If that fails, the problem is in the areas
that Russell discusses:
1) The database is corrupt.
2) The backup is bad.
3) The disk to which you write the backup is bad.
You could narrow this down by backing up the database to another disk.
If the backup on the source server succeeds, then you are presumably
victim to some network problem which corrupts the database when you
copy it. (Or you have a hardware problem on the machine that performs
the copy.)
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#28
| |||
| |||
|
|
SQL Server 2005 Developer Edition for all boxes. I have a small database on a W03S x64 box. I perform a backup using SSMS. No errors. I copy the .bak file ( ~ 0.5 gb ) to an XP machine and use SSMS to restore it. I receive the error : Restore failed for Server 'localhost'. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:1194741) in database "MyDb" as read from the backup set. (Microsoft.SqlServer.Smo) I repeat the process and receive the same error. |
where you took the backup. If that fails, the problem is in the areas
that Russell discusses:
1) The database is corrupt.
2) The backup is bad.
3) The disk to which you write the backup is bad.
You could narrow this down by backing up the database to another disk.
If the backup on the source server succeeds, then you are presumably
victim to some network problem which corrupts the database when you
copy it. (Or you have a hardware problem on the machine that performs
the copy.)
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.