Mark Forums Read

backup always fails on restore

Go Back

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

Reply

Page 1 of 3

1

#1

Old

John A Grandy

Posts: n/a

backup always fails on restore - 09-26-2008 , 07:03 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.

Reply With Quote

#2

Old

John A Grandy

Posts: n/a

Re: backup always fails on restore - 09-26-2008 , 07:21 PM

Could this be because I specified an initial size ( 10gb ) for my .mdf that
is huge compared to amount of data currently stored ?

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Quote:

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.

Reply With Quote

#3

Old

John A Grandy

Posts: n/a

Re: backup always fails on restore - 09-26-2008 , 07:21 PM

Could this be because I specified an initial size ( 10gb ) for my .mdf that
is huge compared to amount of data currently stored ?

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Quote:

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.

Reply With Quote

#4

Old

John A Grandy

Posts: n/a

Re: backup always fails on restore - 09-26-2008 , 07:21 PM

Could this be because I specified an initial size ( 10gb ) for my .mdf that
is huge compared to amount of data currently stored ?

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Quote:

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.

Reply With Quote

#5

Old

John A Grandy

Posts: n/a

Re: backup always fails on restore - 09-26-2008 , 07:21 PM

Could this be because I specified an initial size ( 10gb ) for my .mdf that
is huge compared to amount of data currently stored ?

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Quote:

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.

Reply With Quote

#6

Old

John A Grandy

Posts: n/a

Re: backup always fails on restore - 09-26-2008 , 07:21 PM

Could this be because I specified an initial size ( 10gb ) for my .mdf that
is huge compared to amount of data currently stored ?

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Quote:

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.

Reply With Quote

#7

Old

John A Grandy

Posts: n/a

Re: backup always fails on restore - 09-26-2008 , 07:21 PM

Could this be because I specified an initial size ( 10gb ) for my .mdf that
is huge compared to amount of data currently stored ?

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Quote:

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.

Reply With Quote

#8

Old

John A Grandy

Posts: n/a

Re: backup always fails on restore - 09-26-2008 , 07:21 PM

Could this be because I specified an initial size ( 10gb ) for my .mdf that
is huge compared to amount of data currently stored ?

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Quote:

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.

Reply With Quote

#9

Old

John A Grandy

Posts: n/a

Re: backup always fails on restore - 09-26-2008 , 07:21 PM

Could this be because I specified an initial size ( 10gb ) for my .mdf that
is huge compared to amount of data currently stored ?

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Quote:

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.

Reply With Quote

#10

Old

John A Grandy

Posts: n/a

Re: backup always fails on restore - 09-26-2008 , 07:21 PM

Could this be because I specified an initial size ( 10gb ) for my .mdf that
is huge compared to amount of data currently stored ?

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote

Quote:

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.

Reply With Quote

Reply

Page 1 of 3

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded 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.