Skip to Content
0
Former Member
May 20, 2014 at 07:35 PM

Restore master and user database

260 Views

I am trying to restore master and user database mydb on dev from production copy.

On production, the memory increased, the new devices added.

What I did is:

1. restore master in single user mode.

2. it is restored and the stopped because there is no enough memory.

3. put myserver.cfg back and restart ase 12.5

4. run isql, then run sp_helpdb mydb to check database info:

1> sp_helpdb mydb

2> go

....

Msg 926, Level 14, State 2:

Server 'myserver', Procedure 'sp_helpdb', Line 610:

Database 'mydb' cannot be opened. An earlier attempt at recovery marked it

'suspect'. Check the SQL Server errorlog for information as to the cause.

Msg 7408, Level 16, State 1:

Server 'myserver', Procedure 'sp_helpdb', Line 610:

Could not find a dbtable for database 5.

Msg 926, Level 14, State 2:

Server 'myserver', Procedure 'sp_helpdb', Line 610:

Database 'mydb' cannot be opened. An earlier attempt at recovery marked it

'suspect'. Check the SQL Server errorlog for information as to the cause.

Msg 7408, Level 16, State 1:

Server 'myserver', Procedure 'sp_helpdb', Line 610:

Could not find a dbtable for database 5.

5. then try to load database mydb and got following info:

2> go

Msg 926, Level 14, State 2:

Server 'myserver', Line 1:

Database 'mydb' cannot be opened. An earlier attempt at recovery marked it

'suspect'. Check the SQL Server errorlog for information as to the cause.

1>

then, got to errorlog and find out following info when ase started:

00:00000:00001:2014/05/20 15:20:57.79 server Recovering database 'mydb'.

00:00000:00001:2014/05/20 15:20:57.79 server Started estimating recovery log boundaries for database 'mydb'.

00:00000:00001:2014/05/20 15:20:57.81 server Error: 692, Severity: 20, State: 1

00:00000:00001:2014/05/20 15:20:57.81 server Uninitialized logical page '11952947' was read while accessing object '8' in database '5'. Please contact Sybase Technical Support.

00:00000:00001:2014/05/20 15:20:57.81 server Error: 3414, Severity: 21, State: 1

00:00000:00001:2014/05/20 15:20:57.81 server Database 'mydb' (dbid 5): Recovery failed. Check the SQL Server errorlog for further information as to the cause.

object '8' is syslogs in mydb.

How to fix it and how to restore mydb? I am afraid of trying will damage something. Help please.