restore master database fails

restore master database fails

Post by parle.. » Sun, 20 Feb 2000 04:00:00



Our master database had been corrupted.
I rebuild the master database and extended the master database to the
previous size.
I wanted to reload the backup of the master from tape, but after
restarting sqlserver i got the following.

2000/02/18 19:07:25.37 spid1    Recovering Database 'master'
2000/02/18 19:07:25.37 kernel   udread: Operating system error 38
(Reached end of file.) on device 'D:\MSSQL\DATA\MASTER.DAT' (virtpage
0x0001b58d).
2000/02/18 19:07:25.37 spid1    Error: 5159, Severity: 16, State: 1
2000/02/18 19:07:25.37 spid1    Buffer 2e90640 from database 'master'
has page number 0 in the page header and page number 18569 in the
buffer header
2000/02/18 19:07:25.37 spid1    Cannot recover the master datbase;
exiting

After that i tried another way. I use disk init and disk refit.
But these commands make wrong entries in sysusages.
After changing manually sysusages another disk refit for another
database changes it again

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 

1. restore master database fails

Our master database had been corrupted.
I rebuild the master database and extended the master database to the
previous size.
I wanted to reload the backup of the master from tape, but after
restarting sqlserver i got the following.

2000/02/18 19:07:25.37 spid1    Recovering Database 'master'
2000/02/18 19:07:25.37 kernel   udread: Operating system error 38
(Reached end of file.) on device 'D:\MSSQL\DATA\MASTER.DAT' (virtpage
0x0001b58d).
2000/02/18 19:07:25.37 spid1    Error: 5159, Severity: 16, State: 1
2000/02/18 19:07:25.37 spid1    Buffer 2e90640 from database 'master'
has page number 0 in the page header and page number 18569 in the
buffer header
2000/02/18 19:07:25.37 spid1    Cannot recover the master datbase;
exiting

After that i tried another way. I use disk init and disk refit.
But these commands make wrong entries in sysusages.
After changing manually sysusages another disk refit for another
database changes it again

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Clearing unwanted keypresses.

3. Restore Master Database fails

4. US-VA-DEVELOPER

5. Help wanted : Restoring of Master Database Failed

6. single user mode

7. MSSQL7 service fails to start after restoring master database

8. Master DB restore fails

9. physical restore failed - restore reserved pages failed

10. Restore Master DB to db other than Master?

11. SQL7: restore MSDB without restoring Master?

12. Restoring a database, fails with database not published