Cannot Start the Replication Database

[Former Member]

Hello there,

    I encounter a problem in replication, Once I open the services of SQLServer, (please see error log attached) The replication Database (PSMBFI_REP_RSSD) is not working and it reads in the dbreplicate logs says that :

E. 2014/03/31 08:26:11. ERROR #1028 GLOBAL RS(GLOBAL RS) - \cfginit.c(3961)

    Message from server: Message: 921, State 1, Severity 14 -- 'Database 'PSMBFI_REP_RSSD' has not been recovered yet - please wait and try again.

'.

F. 2014/03/31 08:26:11. FATAL ERROR #18028 GLOBAL RS(GLOBAL RS) - servmain.c(308)

    Initialization failed. Server is shutting down.

Can anybody down here knows what was the problem? I need help

dbreplicate_logs.txt.zip

dbrep_logs.txt.zip

[Former Member]

Check if you have all permistions to devices files (for RSSD database on ASE) in d:\PSMBFI_REP\ and c:\prsdevice\

You can try move all files d:\PSMBFI_REP\PSMBFI_RSSD* and c:\prsdevice\PSMBFI_RSSD* to different folders and then move it back to the same source folders to check if you have read and write permissions

Check all files (when ASE is down):

D:\PSMBFI_REP\PSMBFI_RSSD_dat.dat

D:\PSMBFI_REP\PSMBFI_RSSD_data.dat

D:\PSMBFI_REP\PSMBFI_RSSD_log.dat

d:\PSMBFI_REP\PSMBFI_RSSD1_log.dat

d:\PSMBFI_REP\PSMBFI_RSSD2_log

c:\prsdevice\PSMBFI_RSSD3_log

c:\prsdevice\PSMBFI_RSSD4.log

You can use command to check your disk under OS:

chkdsk <volume drive letter> /r /f

There is also interesting similar problem for SQL Server that is run under VM ESX'i

http://support.microsoft.com/kb/2519834

If your device files are corrupted you will have to use backup of RSSD database and then refresh
replication.

best regards

Tomasz Romanowski

[Former Member]

Hi,

PSMBFI_REP_RSSD is not online.

The error message related to H/W issue has been logged.

You should resolve H/W issue first.

--

00:00000:00000:2014/03/31 09:21:00.53 kernel  sddone: read error on virtual disk 0 block 15364:

00:00000:00000:2014/03/31 09:21:00.53 kernel  sddone: Windows NT system error 1117: Unforseen error.

00:00000:00001:2014/03/31 09:21:00.53 server  Error: 9004, Severity: 24, State: 1

00:00000:00001:2014/03/31 09:21:00.53 server  I/O error detected on disk buffer 0x4775E920 for page request 0, dbid 3.

Regards,