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

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 - UML - How would you draw a try catch in a sequence diagram? -

-
Image
is there standard way of drawing try catch sequence diagrams? i've made attempt based on this feel end result doesn't feel right. code diagram based around: public static void save () { try { filehandle filehandle = gdx.files.external(file); filehandle.writestring(boolean.tostring(constantshandler.soundenabled)+"\n", false); (int = 0; < 5; i++) { filehandle.writestring(integer.tostring(constantshandler.highscores[i])+"\n", true); } } catch (throwable e) { } } my attempt note: know still need add loop. that's ok. fragments meant show conditional control flow in sequence diagram. superstructures puts limitations on use of fragments (see pp. 467 of ss2.1.1). should use critical region try part above. , option catch . however, keep telling can take quite freedom in using uml. it's language , such changes in life time. long reader ge...
Read more

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