Troubleshooting and Error Messages Guide

Home

Troubleshooting and Error Messages Guide

Chapter 3 Error Message Writeups

dump and load Errors (continued)

Error 4322

Severity

Error message text

SQL Server cannot load a dump of the master database that was dumped from an older version of SQL Server. The current master database upgrade version is %ld, the dump master database upgrade version is %ld.

Explanation

Error 4322 is raised when you try to load a dump of the master database that was created on an earlier version of Adaptive Server than your currently installed version.

Action

If you know you do not have a dump of master from your current version level because you did not dump master after you upgraded, and your master database is corrupted, call Sybase Technical Support.

Otherwise, check the current upgrade version of the master dump you are trying to load. For example:

1> load database master from 'master.dump' with headeronly
2> go

Backup Server session id is:  6.  Use this value when executing the 
`sp_volchanged' system stored procedure after fulfilling any volume 
change request from the Backup Server.

Backup Server: 6.28.1.1: Dumpfile name `master_952820A2F8' section 
number 0001 mounted on disk file
`/remote/solaris/rel1100/install/master.dump'

This is a database dump of database ID 6, name `master', from 
Oct  9 1995 11:35AM.  SQL Server version: 
SQL Server/11.0/B/Sun_svr4/OS5.2/1/OPT/Fri Aug 1805:10:26 PDT 1995. 
Backup Server version: 
Backup Server/11.0/B/Sun_svr4/OS5.4/1/OPT/Thu Aug 17 21:54:21 PDT 1995.

Database contains 1536 pages; checkpoint RID=(Rid pageid = 0x405; 
row num = 0xd); next object ID=3031; sort order ID=50, status=0; 
charset ID=1.

Database log version=2; database
upgrade version=1.

The log version and upgrade version have values as follows:

Version	Value Is 0	Value Is 1	Value Is 2
Database log version	10.0.x or earlier	10.1	11.0 or later
Database upgrade version	10.x or earlier	11.0 or later	Not used

Additional information

If you need to call Sybase Technical Support, have the following information ready:

Server version and SWR Rollup level
Server error log
Text of all error messages
Output from load database...with headeronly command if you have what you thought was a current dump
Output from sp_configure "upgrade version"

Versions in which this error is raised

All versions


	Expand Search