SQL 6.5 dump restore failure - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

SQL 6.5 dump restore failure

Author

Topic

simon@westferry.co.uk
Starting Member

5 Posts

Posted - 2004-03-01 : 03:51:36

Hi
I'm getting this message from sql-dmo when restoring a db to another box or even the same box but a new db name.
"LOAD DATABASE encountered page with invalid logical page number 0x6c6c6c6c"

It loaded fine to the original db.
I've checked the device and segment structure is correct.

any ideas - thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-01 : 13:03:06

What happens when you run the LOAD command in Query Analyzer (isql)?

Tara

simon@westferry.co.uk
Starting Member

5 Posts

Posted - 2004-03-02 : 14:22:51

Hi Tara
I get the same message.
Any ideas what might be causing this?
thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-02 : 14:26:09

What is the command that you are running in Query Analyzer?

It sounds like the backup file is corrupt though. I suggest backing up the database again, then trying that new backup file.

Tara

simon@westferry.co.uk
Starting Member

5 Posts

Posted - 2004-03-02 : 16:07:48

load database test from testdump

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-02 : 16:13:37

Try this instead:

LOAD DATABASE test FROM DISK='C:\MSSQL\BACKUP\test.DAT'

Where C:\MSSQL\BACKUP\test.DAT is the path and file name to the backup.

Tara

simon@westferry.co.uk
Starting Member

5 Posts

Posted - 2004-03-02 : 16:19:13

Msg 3104, Level 16, State 1
LOAD DATABASE encountered page with invalid logical page number 0x6c6c6c6c.
Msg 3203, Level 16, State 1
Read on dump device 'd:\MSSQL\BACKUP\test.DAT' failed, vsn=0 return=2130 status=-2. Please consult the SQL Server error log for more details.
Msg 3103, Level 16, State 1
Unexpected end-of-dump while loading database, attempting to continue. Please verify database integrity.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-02 : 16:31:51

Does the SQL Server Error Log have more details? Like is the server out of space? If the log doesn't have more details, then I'd say that the backup file is corrupt.

Tara

simon@westferry.co.uk
Starting Member

5 Posts

Posted - 2004-03-02 : 16:43:18

Hi - no more info in the log. thanks for your help anyway.
Simon

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources