Author Topic: Database Suspect  (Read 51182 times)

Yusuf

  • Administrator
  • Sr. Member
  • ****
  • Posts: 1,335
    • Orisinil.com
Database Suspect
« on: September 11, 2010, 10:09:31 AM »
Ini ada sumbangan dari rekan kita yg sudah mengalaminya:

Untuk memperbaiki database yg suspect, jalankan perintah-perintah ini pada Query Analyzer atau SQL Server Management Studio:

Code: [Select]
  EXEC sp_resetstatus ‘yourDBname’;
  ALTER DATABASE yourDBname SET EMERGENCY
  DBCC checkdb(‘yourDBname’)
  ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)
  ALTER DATABASE yourDBname SET MULTI_USER

Sumber: http://gargmanoj.wordpress.com/2008/07/17/how-to-repair-a-sql-server-2005-suspect-database/

d3k4

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 312
Re: Database Suspect
« Reply #1 on: September 11, 2010, 07:28:10 PM »
Mantab...
makasih BOS..
jadi nambah ilmu....
BECIK KE TITIK... OLO KETORO...

Yusuf

  • Administrator
  • Sr. Member
  • ****
  • Posts: 1,335
    • Orisinil.com
Re: Database Suspect
« Reply #2 on: September 11, 2010, 09:40:40 PM »
yourDBname diganti jadi otomax:

Code: [Select]
  EXEC sp_resetstatus ‘otomax’;
  ALTER DATABASE otomax SET EMERGENCY
  DBCC checkdb(‘otomax’)
  ALTER DATABASE otomax SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  DBCC CheckDB (‘otomax’, REPAIR_ALLOW_DATA_LOSS)
  ALTER DATABASE otomax SET MULTI_USER


bralingtronik

  • User OtomaX
  • Full Member
  • ***
  • Posts: 930
Re: Database Suspect
« Reply #3 on: September 12, 2010, 08:41:19 AM »
Mantabbb BIG BOSS  ;D ;D
bookmark dulu ahhh, belum ada kasus neehh
BRALING COMPUTER MALANG (BRALINGTRONIK)
JL. TELUK MANDAR NO 51 A ARJOSARI MALANG
TLP/SMS/WA :081334987766
MONGGO MAMPIR LAPAK H2H

didiek

  • User OtomaX --
  • Hero Member
  • *****
  • Posts: 2,043
  • semoga langkah kaki selalu menuju jalan yg benar
    • SmartReload88
Re: Database Suspect
« Reply #4 on: September 14, 2010, 08:57:53 AM »
finally... berbagi uang, uang habis.... berbagi ilmu, ilmu nambah teruuss...  ;D ;D
Toko  : Jl Bunga Cengkeh 59c (0341)7023232  Rumah: Puskopad A-16 Singosari (0341)457614 Malang
Telp    : 03417742743  SMS: 081233182223, 085736002223, 08885545882 (WhatsApp) BB 30b118c5

Want to know everything about me Gabung ke group SmartReload88
http://smartreload88.com dan http://malang-grosir.com

titanium_ponsel

  • User OtomaX --
  • Jr. Member
  • **
  • Posts: 247
Re: Database Suspect
« Reply #5 on: September 23, 2010, 01:17:11 AM »
kok ndk bisa ya ???
replay nya
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '‘'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '‘'.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '‘'.
knp ya???

Yusuf

  • Administrator
  • Sr. Member
  • ****
  • Posts: 1,335
    • Orisinil.com
Re: Database Suspect
« Reply #6 on: September 23, 2010, 07:48:07 AM »
tanda ' nya coba bos hapus, ketik ulang...

titanium_ponsel

  • User OtomaX --
  • Jr. Member
  • **
  • Posts: 247
Re: Database Suspect
« Reply #7 on: September 24, 2010, 12:26:47 AM »
The suspect flag on the database "otomax" is already reset.
DBCC results for 'Otomax'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 834 rows in 8 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 120 rows in 1 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 131 rows in 2 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 834 rows in 10 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 120 rows in 1 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 131 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 14 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 120 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 166 rows in 4 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 663 rows in 12 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 1 rows in 1 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 332 rows in 6 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 465 rows in 3 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 393 rows in 118 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 14 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 157 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 105 rows in 1 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'jawaban'.
There are 124 rows in 2 pages for object "jawaban".
DBCC results for 'transaksi'.
There are 1794961 rows in 45225 pages for object "transaksi".
DBCC results for 'mutasi'.
There are 3054402 rows in 33120 pages for object "mutasi".
DBCC results for 'parameter'.
There are 210 rows in 3 pages for object "parameter".
DBCC results for 'pengirim'.
There are 765 rows in 4 pages for object "pengirim".
DBCC results for 'produk'.
There are 129 rows in 1 pages for object "produk".
DBCC results for 'sms_sender'.
There are 2 rows in 1 pages for object "sms_sender".
DBCC results for 'operator'.
There are 15 rows in 1 pages for object "operator".
DBCC results for 'inbox'.
There are 6880967 rows in 127211 pages for object "inbox".
DBCC results for 'terminal'.
There are 33 rows in 1 pages for object "terminal".
DBCC results for 'biaya'.
There are 63 rows in 1 pages for object "biaya".
DBCC results for 'tiket_deposit'.
There are 24463 rows in 138 pages for object "tiket_deposit".
DBCC results for 'data_bank'.
There are 24693 rows in 386 pages for object "data_bank".
DBCC results for 'level'.
There are 20 rows in 1 pages for object "level".
DBCC results for 'komisi'.
There are 172 rows in 1 pages for object "komisi".
DBCC results for 'hlr'.
There are 1 rows in 1 pages for object "hlr".
DBCC results for 'log_sistem'.
There are 82605 rows in 1239 pages for object "log_sistem".
DBCC results for 'sms_center'.
There are 19 rows in 1 pages for object "sms_center".
DBCC results for 'produk_level'.
There are 144 rows in 1 pages for object "produk_level".
DBCC results for 'outbox'.
There are 7238473 rows in 169880 pages for object "outbox".
DBCC results for 'parsing'.
There are 268 rows in 6 pages for object "parsing".
DBCC results for 'modul'.
There are 41 rows in 1 pages for object "modul".
DBCC results for 'reseller'.
There are 392 rows in 7 pages for object "reseller".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'fisik'.
There are 60 rows in 1 pages for object "fisik".
DBCC results for 'auto_respon'.
There are 14 rows in 1 pages for object "auto_respon".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'Otomax'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC results for 'Otomax'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 834 rows in 8 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 120 rows in 1 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 131 rows in 2 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 834 rows in 10 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 120 rows in 1 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 131 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 14 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 120 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 166 rows in 4 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 663 rows in 12 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 1 rows in 1 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 332 rows in 6 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 465 rows in 3 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 393 rows in 118 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 14 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 157 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 105 rows in 1 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'jawaban'.
There are 124 rows in 2 pages for object "jawaban".
DBCC results for 'transaksi'.
There are 1794961 rows in 45225 pages for object "transaksi".
DBCC results for 'mutasi'.
There are 3054402 rows in 33120 pages for object "mutasi".
DBCC results for 'parameter'.
There are 210 rows in 3 pages for object "parameter".
DBCC results for 'pengirim'.
There are 765 rows in 4 pages for object "pengirim".
DBCC results for 'produk'.
There are 129 rows in 1 pages for object "produk".
DBCC results for 'sms_sender'.
There are 2 rows in 1 pages for object "sms_sender".
DBCC results for 'operator'.
There are 15 rows in 1 pages for object "operator".
DBCC results for 'inbox'.
There are 6880967 rows in 127211 pages for object "inbox".
DBCC results for 'terminal'.
There are 33 rows in 1 pages for object "terminal".
DBCC results for 'biaya'.
There are 63 rows in 1 pages for object "biaya".
DBCC results for 'tiket_deposit'.
There are 24463 rows in 138 pages for object "tiket_deposit".
DBCC results for 'data_bank'.
There are 24693 rows in 386 pages for object "data_bank".
DBCC results for 'level'.
There are 20 rows in 1 pages for object "level".
DBCC results for 'komisi'.
There are 172 rows in 1 pages for object "komisi".
DBCC results for 'hlr'.
There are 1 rows in 1 pages for object "hlr".
DBCC results for 'log_sistem'.
There are 82605 rows in 1239 pages for object "log_sistem".
DBCC results for 'sms_center'.
There are 19 rows in 1 pages for object "sms_center".
DBCC results for 'produk_level'.
There are 144 rows in 1 pages for object "produk_level".
DBCC results for 'outbox'.
There are 7238473 rows in 169880 pages for object "outbox".
DBCC results for 'parsing'.
There are 268 rows in 6 pages for object "parsing".
DBCC results for 'modul'.
There are 41 rows in 1 pages for object "modul".
DBCC results for 'reseller'.
There are 392 rows in 7 pages for object "reseller".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'fisik'.
There are 60 rows in 1 pages for object "fisik".
DBCC results for 'auto_respon'.
There are 14 rows in 1 pages for object "auto_respon".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'Otomax'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

kok ada error nya ya???

AbiTamim

  • Dealer OtomaX
  • Sr. Member
  • ****
  • Posts: 1,976
Re: Database Suspect
« Reply #8 on: October 31, 2010, 06:18:36 PM »
@ atasku
Memang ada pesan Error tapi sukses, suspect hilang
tested pada pasien
Pengumuman : Bagi teman-teman server yg dulu pernah gabung h2h di saya NajaCell & JalaPulsa bila masih ada deposit silahkan transaksi atau ajukan refund
Selengkapnya kontak NoHP/WhatsApp/Telegram : 082140609087
Telegram : @OtomaXDealer

autronik

  • User OtomaX --
  • Newbie
  • *
  • Posts: 66
  • to be a better man
Re: Database Suspect
« Reply #9 on: October 31, 2010, 07:00:19 PM »
ikut liat perkembangan dolo..
Autronik
OtomaX Lite Ver 2.6
OID: 17399916062b541a592e9c0e6ef294

:: CPU : IP Dual Core E2140, RAM 1 GB
:: OS : Win XP Profesional SP 2
:: Koneksi Internet : Smartfren EVDO + flexi (backup)
:: Anti Virus : AVAST Free Antivirus 6.0
:: Hp : 087891906080 (sms)
:: ym cs : cs_autronik
:: gtalk : masfreeze
:: Alamat : Jl. Arif Rahman Hakim 8a Sukolilo, Surabaya.

zurigh

  • Jr. Member
  • **
  • Posts: 346
Re: Database Suspect
« Reply #10 on: November 15, 2010, 11:28:50 PM »
Database Suspect apa ya ??? ???
kesini ga ngerti http://gargmanoj.wordpress.com/2008/07/17/how-to-repair-a-sql-server-2005-suspect-database/
maklum newbie jarang makan roti ;D
« Last Edit: November 15, 2010, 11:31:00 PM by zurigh »

H2H MURAH TRX Wushh..Wushh..
OtomaX : Versi Tiket
OID : ORI
Backup inet & PLN : Hadirr
CS Ready 08:00 s/d 22:00 NO BISU NO OFFLINE

idzoel

  • User OtomaX
  • Newbie
  • *
  • Posts: 29
Re: Database Suspect
« Reply #11 on: January 02, 2011, 10:13:14 PM »
mohon dicek pak bigboss, beberapa kali benerin database otomax yg bermasalah ( terutama yg salah installan dari awal => maksudnya folder otomax.exe dan file .mdf / .ldf nya jadi satu folder), saya coba pake script ini, alhamdulillah sukses terus  ;D,

Code: [Select]
USE master;
GO
ALTER DATABASE otomax SET EMERGENCY
GO
ALTER DATABASE otomax SET SINGLE_USER
GO
DBCC CHECKDB (otomax, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
GO

USE otomax;

DBCC CHECKDB WITH NO_INFOMSGS;
GO

USE otomax
ALTER DATABASE [otomax] SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE ([otomax_log])
GO
ALTER DATABASE [otomax] SET RECOVERY FULL
DBCC SHRINKFILE (otomax, 1) WITH NO_INFOMSGS

ALTER DATABASE otomax SET MULTI_USER


kalo ada yg salah mohon dikoreksi ... maklum nubie
.::: SIMPLE PULSA :::.
JL Krida Nirmala Blok B1 / 10c Komp Depkes
Kel. Sunter Jaya Kec.Tanjung Priok  Jakut
CP & WA : 08111925670  BB : D205E1D2

skullz

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 328
Re: Database Suspect
« Reply #12 on: January 12, 2011, 01:53:08 AM »


penyakitnya apa ya??
sudah coba semua trik di atas hasilnya masih nihil...
harus gimana ya  ??? ??? ???
di tab Produk juga begitu...

skullz

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 328
Re: Database Suspect
« Reply #13 on: January 12, 2011, 10:10:21 AM »
oh iya, nambah produk juga ga mau
Mmmm Sepertinya kasus ini lumayan berat :( :( :(
didatabase sich ga ada indikasi suspect
Help me pleaseeeeee
« Last Edit: January 12, 2011, 10:29:54 AM by skullz »

skullz

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 328
Re: Database Suspect
« Reply #14 on: January 12, 2011, 10:49:14 AM »
case solved
dengan cara menghapus

 ;D ;D ;D
bagi yang mempunyai masaalah yang sama jangan lupa backup DB sebelum modifikasi tabel

satelitpulsa

  • User OtomaX --
  • Jr. Member
  • **
  • Posts: 132
Re: Database Suspect
« Reply #15 on: January 14, 2011, 09:19:01 PM »
finally... berbagi uang, uang habis.... berbagi ilmu, ilmu nambah teruuss...  ;D ;D

Setuju...
new bie mw blajar dulu sama all big boss..

uyan_kids

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 212
  • H2H STOK LANCAR!!
Re: Database Suspect
« Reply #16 on: February 20, 2011, 03:39:02 PM »
OID = OID: CigJdSsdug_XnFTgk0xzdL09JhMJVeVhA
ym = uon.mura  & uon_mura

alamat = jl.notodingratan 160 solo JATENG

uyan_kids

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 212
  • H2H STOK LANCAR!!
Re: Database Suspect
« Reply #17 on: February 20, 2011, 03:40:33 PM »
OID = OID: CigJdSsdug_XnFTgk0xzdL09JhMJVeVhA
ym = uon.mura  & uon_mura

alamat = jl.notodingratan 160 solo JATENG

Tanalodu

  • User OtomaX --
  • Jr. Member
  • **
  • Posts: 264
Re: Database Suspect
« Reply #18 on: March 25, 2011, 11:07:40 AM »

Ini ada sumbangan dari rekan kita yg sudah mengalaminya:

Untuk memperbaiki database yg suspect, jalankan perintah-perintah ini pada Query Analyzer atau SQL Server Management Studio:

Code: [Select]
  EXEC sp_resetstatus ‘yourDBname’;
  ALTER DATABASE yourDBname SET EMERGENCY
  DBCC checkdb(‘yourDBname’)
  ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)
  ALTER DATABASE yourDBname SET MULTI_USER

Sumber: http://gargmanoj.wordpress.com/2008/07/17/how-to-repair-a-sql-server-2005-suspect-database/

Nambah dikit...
Quote from: Manoj Garg

You should keep one thing in mind while using the above queries that the repair mode used here , REPAIR_ALLOW_DATA_LOSS, is a one way operation i.e. once the database is repaired all the actions performed by these queries can’t be undone. There is no way to go back to the previous state of the database. So as a precautionary step you should take backup of your database before executing above mentioned queries.
OID: 38426709993cca9cc48b0b3dbb6c95

deydi

  • User OtomaX --
  • Sr. Member
  • ****
  • Posts: 1,271
  • pm
    • Pasang Iklan Baris GRATIS
Re: Database Suspect
« Reply #19 on: January 24, 2012, 10:05:35 PM »
tanda ' nya coba bos hapus, ketik ulang...

pakai ini

 EXEC sp_resetstatus ‘otomax’;
  ALTER DATABASE otomax SET EMERGENCY
  DBCC checkdb(‘otomax’)
  ALTER DATABASE otomax SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  DBCC CheckDB (‘otomax’, REPAIR_ALLOW_DATA_LOSS)
  ALTER DATABASE otomax SET MULTI_USER

hasilnya :

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '‘'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '‘'.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '‘'.



saya udah coba hapus '

EXEC sp_resetstatus otomax;
ALTER DATABASE otomax SET EMERGENCY
BCC checkdb(otomax)
ALTER DATABASE otomax SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (otomax, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE otomax SET MULTI_USER

hasilnya

Msg 102, Level 15, State 6, Line 3
Incorrect syntax near 'checkdb'.

« Last Edit: January 24, 2012, 10:06:50 PM by deydi »
http://www.dmtronik.com
http://www.manadowebhost.com
YM : dmtronik_cs, cs_dmtronik, otomax_manado