SQL Server 2000 to 2005 Backup failing.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server 2000 to 2005 Backup failing.

Author

Topic

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2009-10-07 : 10:34:17

I am trying to restore a 169GB Backup file from a Backup made on my SQL Server 2000 (SP4) Standard Edition Server to a SQL Server 2005 (SP3)Standard Edition Instance.

I copied the .bak file locally to the SQL Server 2005 Server.

I then issued my restore command like this:

RESTORE DATABASE [ARCBaseKoCTrad] FROM  DISK = N'g:\ARCBaseKoCTrad_db_200910062048.BAK' WITH  FILE = 1,  MOVE N'ARCBaseKoCTradPrimary' TO N'E:\MSSQL\KOCSQLDEV01\Datafiles\ARCBaseKoCTradPrimary.mdf',  MOVE N'TEMP01' TO N'E:\MSSQL\KOCSQLDEV01\Datafiles\TEMP01.ndf',  MOVE N'TEMPID01' TO N'E:\MSSQL\KOCSQLDEV01\Datafiles\TEMPID01.ndf',  MOVE N'INDX01' TO N'E:\MSSQL\KOCSQLDEV01\Datafiles\INDXARCBaseTrad01.ndf',  MOVE N'LTBL01' TO N'E:\MSSQL\KOCSQLDEV01\Datafiles\LTBLARCBaseTrad01.ndf',  MOVE N'INDXT01' TO N'E:\MSSQL\KOCSQLDEV01\Datafiles\INDXTARCBaseTrad01.ndf',  MOVE N'LTBLT01' TO N'E:\MSSQL\KOCSQLDEV01\Datafiles\LTBLTARCBaseTrad01.ndf',  MOVE N'IFD' TO N'E:\MSSQL\KOCSQLDEV01\Datafiles\IFD_Data.NDF',  MOVE N'LOG01' TO N'F:\MSSQL\KOCSQLDEV01\logfiles\ARCBaseKoCTrad_log.LDF',  NOUNLOAD,  REPLACE,  STATS = 10
GO

Here are the results:
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (0:0) in database "ARCBaseKoCTrad" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Also, here are the results of
RESTORE FILELISTONLY FROM DISK='G:\ARCBaseKoCTrad_db_200910062048.BAK'

ARCBaseKoCTradPrimary	E:\Microsoft SQL Server\Data\MSSQL$ARCBASETEST\Data\ARCBaseKoCTradPrimary.mdf	D	PRIMARY	10485760	35184372080640	1	0	0	00000000-0000-0000-0000-000000000000	0	0	0	512	1	NULL	290637000000122900002	3FC466F9-670F-493F-B775-BA0A73200B69	0	1
TEMP01	E:\Microsoft SQL Server\Data\MSSQL$ARCBASETEST\Data\TEMP01.ndf	D	TEMPTBL	10485760	35184372080640	3	5000000003900001	0	00000000-0000-0000-0000-000000000000	0	0	0	512	2	NULL	290637000000122900002	3FC466F9-670F-493F-B775-BA0A73200B69	0	1
TEMPID01	E:\Microsoft SQL Server\Data\MSSQL$ARCBASETEST\Data\TEMPID01.ndf	D	TEMPINDX	10485760	35184372080640	4	5000000004800001	0	00000000-0000-0000-0000-000000000000	0	0	0	512	3	NULL	290637000000122900002	3FC466F9-670F-493F-B775-BA0A73200B69	0	1
INDX01	E:\Microsoft SQL Server\Data\MSSQL$ARCBASETEST\Data\INDXARCBaseTrad01.ndf	D	INDX	10485760	35184372080640	5	5000000005700001	0	00000000-0000-0000-0000-000000000000	0	0	0	512	4	NULL	290637000000122900002	3FC466F9-670F-493F-B775-BA0A73200B69	0	1
LTBL01	E:\Microsoft SQL Server\Data\MSSQL$ARCBASETEST\Data\LTBLARCBaseTrad01.ndf	D	LTBL	10485760	35184372080640	6	5000000006600001	0	00000000-0000-0000-0000-000000000000	0	0	0	512	5	NULL	290637000000122900002	3FC466F9-670F-493F-B775-BA0A73200B69	0	1
INDXT01	E:\Microsoft SQL Server\Data\MSSQL$ARCBASETEST\Data\INDXTARCBaseTrad01.ndf	D	INDXT	8432975872	35184372080640	7	5000000007500001	0	00000000-0000-0000-0000-000000000000	0	0	0	512	6	NULL	290637000000122900002	3FC466F9-670F-493F-B775-BA0A73200B69	0	1
LTBLT01	E:\Microsoft SQL Server\Data\MSSQL$ARCBASETEST\Data\LTBLTARCBaseTrad01.ndf	D	LTBLT	29364125696	35184372080640	8	5000000008400001	0	00000000-0000-0000-0000-000000000000	0	0	0	512	7	NULL	290637000000122900002	3FC466F9-670F-493F-B775-BA0A73200B69	0	1
IFD	E:\Microsoft SQL Server\Data\MSSQL$ARCBASETEST\Data\IFD_Data.NDF	D	IFD	63206064128	35184372080640	9	6000000307300001	0	00000000-0000-0000-0000-000000000000	0	0	0	512	8	NULL	290637000000122900002	3FC466F9-670F-493F-B775-BA0A73200B69	0	1
LOG01	E:\Microsoft SQL Server\Data\MSSQL$ARCBASETEST\Data\ARCBaseKoCTrad_log.LDF	L	NULL	516096	35184372080640	2	0	0	00000000-0000-0000-0000-000000000000	0	0	0	512	0	NULL	0	00000000-0000-0000-0000-000000000000	0	0

Any ideas why this might be failing?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-07 : 16:10:33

That error means your backup is bad. I'd run DBCC CHECKDB on the source database. If that doesn't return any errors, then rerun the backup.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources