MS RMS SQL Server Database error -

-

we have had issue our rms_headquarters(front end application access database) database running on sql express 2005.

after checking event log on server, came across few errors related hard disk , sqlserver.

disk error snapshot

sqlexpress error

i have executed 2 commands follows find out error in disk or on sql database.

chkdsk : system found bad sectors on hard disk ran code without /f information.

dbcc checkdb all_errormsgs, no_infomsgs , outcome below.

i ran chkdsk /f resolve disk error. command helped hq database , running (application working fine point). ran dbcc checkdb all_errormsgs, no_infomsgs on sql server check database status. dbcc executed few errors, please see below.

msg 8928, level 16, state 1, line 1 object id 1429580131, index id 1, partition id 72057598907908096, alloc unit id 72057598960730112 (type in-row data): page (1:235150) not processed.  see other errors details. msg 8941, level 16, state 2, line 1 table error: object id 1429580131, index id 1, partition id 72057598907908096, alloc unit id 72057598960730112 (type in-row data), page (1:235150). test (sorted [i].offset <= m_freedata)  failed. slot 0, offset 0xffff invalid. msg 8976, level 16, state 1, line 1 table error: object id 1429580131, index id 1, partition id 72057598907908096, alloc unit id 72057598960730112 (type in-row data). page (1:235150) not seen in scan although  parent (1:306430) , previous (1:235149) refer it. check previous errors. msg 8978, level 16, state 1, line 1 table error: object id 1429580131, index id 1, partition id 72057598907908096, alloc unit id 72057598960730112 (type in-row data). page (1:235151) missing reference previous page  (1:235150). possible chain linkage problem. checkdb found 0 allocation errors , 4 consistency errors in table 'tenderentry' (object id 1429580131). checkdb found 0 allocation errors , 4 consistency errors in database 'rms_headquarters'. repair_allow_data_loss minimum repair level errors found dbcc checkdb (rms_headquarters).

system information:

  • os: windows server 2003 r2
  • sql server: sql server 2005 (9.0.4035)

i have backup sunday(20th april 2015) evening, backup doesn’t report error.

please advise me should done in matter: (a) restore database backup dated 20th april 2015 (what data 21st onwards lost) (b) continue database , ignore ‘tenderentry’ table errors

your appreciated.

regards pratik

(a)restore database backup dated 20th april 2015 (what data 21st onwards lost)

yes data lost because backup last updated on 20 april 2015.

(b)continue database , ignore ‘tenderentry’ table errors

personally not suggest because might possible have bigger corruption issues in future. fixing corruption earlier stage should on priority. helps maintain database health.

and please not run dbcc checkdb repair_allow_data_loss without knowing effect of it.


Comments

Post a Comment

Popular posts from this blog

c++ - No viable overloaded operator for references a map -

-
i trying use map can make tag names reference number. when try , use it, in code error (6 in total every time reference map): src/main.cpp:25:45: error: no viable overloaded operator[] type 'std::map<std::string, std::string>' const char* idcs = node.child_value(tagmap[3]); this code: #include "pugi/pugixml.hpp" #include <iostream> #include <string> #include <map> int main() { pugi::xml_document doca, docb; std::map<std::string, pugi::xml_node> mapa, mapb; std::map<std::string, std::string> tagmap {{"1", "data"}, {"2", "entry"}, {"3", "id"}, {"4", "content"}}; if (!doca.load_file("a.xml") || !docb.load_file("b.xml")) { std::cout << "can't find input files"; return 1; } (auto& node: doca.child(tagmap[1]).children(tagmap[2])) { co
Read more

java - Custom OutputStreamAppender not run: LOGBACK: No context given for <MYAPPENDER> -

-
i wish write custom appender on basis of outputstreamappender . wrote following class package tests; import java.io.ioexception; import java.io.outputstream; import ch.qos.logback.core.outputstreamappender; public class myappender<e> extends outputstreamappender<e> { public myappender() { system.out.println("myappender created"); setoutputstream(new outputstream() { @override public void write(int b) throws ioexception { throw new unsupportedoperationexception(); } }); } } then wrote following runner: package tests; import org.slf4j.loggerfactory; import ch.qos.logback.classic.logger; public class runner { private static final logger log = (logger) loggerfactory.getlogger(runner.class); public static void main(string[] args) { //log.addappender(new myappender<iloggingevent>()); log.info("hello world"); } } finall
Read more

java - Cannot secure connection using TLS -

-
i'm trying establish secure socket connection between java client applet (built jdk 1.7.0_75-b13) , vc++ server application. as test vehicle, used vc++ client/server sample found in msdn forums, modified use schannel , able establish socket using cipher suite tls_rsa_with_aes_128_cbc_sha. works of tls 1.0/1.1/1.2. when try opening socket java applet same server application, connection rejected server reporting following: tls 1.0 acceptsecuritycontext failed: 0x80090327 tls 1.1 acceptsecuritycontext failed: 0x80090331 tls 1.2 acceptsecuritycontext failed: 0x80090331 this java code used create socket: debugprint("setting secure connection"); sslsocketfactory sslsocketfactory = (sslsocketfactory) sslsocketfactory.getdefault(); sslsocket sslsocket = (sslsocket) sslsocketfactory.createsocket("127.0.0.1", socketnumber); debugprint("starting handshake"); sslsocket.settcpnodelay(true); sslsocket.setsolinger(false, 0); sslsocket.s
Read more