Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Recover Suspect Database
 Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

mayoorsubbu
Yak Posting Veteran

India
95 Posts

Posted - 08/10/2013 :  03:04:30  Show Profile  Reply with Quote
Dear All,

I am running SQL Server 2000. My database is running in Suspect mode. When I explore the database through the enterprise manager no objects can be seen. I am not able to set the database in EMERGENCY mode which is the first step to recover the same. I tried to run the following script

ALTER DATABASE [MyDatabase] SET EMERGENCY

Can someone suggest a way out.

Edited by - mayoorsubbu on 08/10/2013 03:49:48

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 08/10/2013 :  18:49:43  Show Profile  Visit tkizer's Homepage  Reply with Quote
Have you tried to restore the database?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rhein
Starting Member

9 Posts

Posted - 12/17/2017 :  02:51:05  Show Profile  Reply with Quote
<strong><a href="http://sv.bikinicool.top/nyheter-c-10.html">nya baddräkter till salu</a></strong><br><strong><a href="http://www.bikinicool.top/sv/nyheter-c-10.html">nya baddräkter till salu</a></strong><br>[b][url=http://www.bikinicool.top/sv/nyheter-c-10.html]billiga nya bikini[/url][/b][b]<a href="http://sv.bikinicool.top/nyheter-c-10.html">nya bikinis till salu</a>[/b][b][url=http://www.bikinicool.top/sv/nyheter-c-10.html]nya bikinis till salu[/url][/b]Handla Baddräkt Cover Up till låga priserlanguage:[url=http://de.bikinicool.top]Deutsch[/url] [url=http://fr.bikinicool.top]Français[/url] [url=http://it.bikinicool.top]italiano[/url] [url=http://es.bikinicool.top] Español[/url] [url=http://pt.bikinicool.top]Português[/url] [url=http://jp.bikinicool.top]???[/url] [url=http://ru.bikinicool.top]russian[/url] [url=http://ar.bikinicool.top]arabic[/url] [url=http://no.bikinicool.top]norwegian[/url] [url=http://sv.bikinicool.top]swedish[/url] [url=http://da.bikinicool.top]danish[/url] [url=http://nl.bikinicool.top]dutch[/url] [url=http://fi.bikinicool.top]finland[/url] <a href="http://ie.bikinicool.top"><img src="http://sv.bikinicool.top/langimg/gaicon.gif" alt="finland" title=" finland " height="15" width="24"></a> [url=http://www.bikinicool.top]English[/url] [url=http://sv.bikinicool.top/index.php?main_page=Payment_Methods]Betalning | [/url][url=http://sv.bikinicool.top/index.php?main_page=shippinginfo]Frakt u0026 Retur | [/url][url=http://sv.bikinicool.top/index.php?main_page=Payment_Methods]Grossist | [/url][url=http://sv.bikinicool.top/index.php?main_page=contact_us]Kontakta oss[/url] Welcome! [url=http://sv.bikinicool.top/index.php?main_page=login]Logga in[/url]eller [url=http://sv.bikinicool.top/index.php?main_page=create_account]Registrera[/url] [url=http://sv.bikinicool.top/index.php?main_page=shopping_cart]Powered by Zen Cart :: Konsten att e-handel[/url]din vagn är tom [url=http://sv.bikinicool.top/]Powered by Zen Cart :: Konsten att e-handel[/url] [url=http://sv.bikinicool.top/index.php]Hem[/url][url=http://sv.bikinicool.top/one-piece-c-1.html]En bit[/url][url=http://sv.bikinicool.top/two-piece-c-5.html]Tvådelad[/url][url=http://sv.bikinicool.top/tankini-c-11.html]tankini[/url][url=http://sv.bikinicool.top/cover-up-c-13.html]Skyla över[/url][url=http://sv.bikinicool.top/one-piece-one-piece-swimsuit-c-1_2.html]One Piece Baddräkt[/url][url=http://sv.bikinicool.top/one-piece-swimdress-c-1_3.html]swimdress[/url][url=http://sv.bikinicool.top/one-piece-monokinis-c-1_4.html]Monokinis[/url][url=http://sv.bikinicool.top/two-piece-bikini-swimsuit-c-5_6.html]bikini Baddräkt[/url][url=http://sv.bikinicool.top/two-piece-skirted-bikinis-c-5_7.html]Skirted Bikinis[/url]<a href="http://sv.bikinicool.top/two-piece-designer-bikini-c-5_8.html">Designer Bikini</a>[url=http://sv.bikinicool.top/mala-mala-banded-clearance-top-only-size-2x-p-508.html]bikini Separerar[/url] Valuta US Dollar Euro GB Pound Canadian Dollar Australian Dollar Jappen Yen Norske Krone Swedish Krone Danish Krone CNYKategorier[url=http://sv.bikinicool.top/tv%C3%A5-piece-c-5.html]två Piece[/url]<a class="category-top" href="http://sv.bikinicool.top/bikini-cover-up-set-c-14.html">Bikini & Cover Up Set</a>[url=http://sv.bikinicool.top/barnens-badkl%C3%A4der-c-17.html]Barnens Badkläder[/url][url=http://sv.bikinicool.top/nyheter-c-10.html]Nyheter[/url][url=http://sv.bikinicool.top/one-piece-c-1.html]One Piece[/url]<a class="category-top" href="http://sv.bikinicool.top/skirtini-c-12.html">skirtini</a><a class="category-top" href="http://sv.bikinicool.top/sportkl%C3%A4der-c-25.html">sportkläder</a><a class="category-top" href="http://sv.bikinicool.top/tankini-c-11.html">Tankini</a>[url=http://sv.bikinicool.top/tysta-ner-c-13.html]TYSTA NER[/url]<a class="category-top" href="http://sv.bikinicool.top/utf%C3%B6rs%C3%A4ljning-c-26.html">Utförsäljning</a>[url=http://sv.bikinicool.top/uvskydd-badkl%C3%A4der-c-23.html]UV-skydd Badkläder[/url][url=http://sv.bikinicool.top/yoga-wear-c-24.html]yoga Wear[/url]Utvalda - [url=http://sv.bikinicool.top/featured_products.html] [mer][/url][url=http://sv.bikinicool.top/qihai-swimdress-qh2139-p-78.html]Qihai swimdress - QH2139[/url][url=http://sv.bikinicool.top/qihai-swimdress-qh2139-p-78.html]Qihai swimdress - QH2139[/url]SEK 1,695 SEK 657Spara: 61% mindre[url=http://sv.bikinicool.top/in-bloom-skirtini-p-681.html]In Bloom Skirtini[/url]<a class="sidebox-products" href="http://sv.bikinicool.top/in-bloom-skirtini-p-681.html">In Bloom Skirtini</a>SEK 3,650 SEK 709Spara: 81% mindre[url=http://sv.bikinicool.top/check-me-out-slider-p-102.html]Check Me Out Slider[/url]<a class="sidebox-products" href="http://sv.bikinicool.top/check-me-out-slider-p-102.html">Check Me Out Slider</a>SEK 2,137 SEK 934Spara: 56% mindre [url=http://sv.bikinicool.top/]Hem[/url] :: TYSTA NERTYSTA NERVisar [b]1[/b] till [b]20[/b] (av [b]149[/b] produkter) 1[/b] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=2&sort=20a]2[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=3&sort=20a]3[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=4&sort=20a]4[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=5&sort=20a]5[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=6&sort=20a]...[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=8&sort=20a]8[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=2&sort=20a][Nästa >>][/url] [url=http://sv.bikinicool.top/animal-accent-monokini-p-289.html]Animal Accent Monokini[/url][url=http://sv.bikinicool.top/animal-accent-monokini-p-289.html]Animal Accent Monokini[/url]SEK 2,232 SEK 432Spara: 81% mindre[url=http://sv.bikinicool.top/beach-club-sarong-p-693.html]Beach Club Sarong[/url][url=http://sv.bikinicool.top/beach-club-sarong-p-693.html]Beach Club Sarong[/url]SEK 2,266 SEK 605Spara: 73% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bn113073-p-2.html]Bonishi Bikini Baddräkt med Cover Up - BN113073[/url][url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bn113073-p-2.html]Bonishi Bikini Baddräkt med Cover Up - BN113073[/url]SEK 2,024 SEK 727Spara: 64% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124004-p-3.html]Bonishi Bikini Baddräkt med Cover Up - BNL124004[/url][url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124004-p-3.html]Bonishi Bikini Baddräkt med Cover Up - BNL124004[/url]SEK 3,538 SEK 597Spara: 83% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124006-p-1.html]Bonishi Bikini Baddräkt med Cover Up - BNL124006[/url][url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124006-p-1.html]Bonishi Bikini Baddräkt med Cover Up - BNL124006[/url]SEK 2,067 SEK 571Spara: 72% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124007-p-5.html]Bonishi Bikini Baddräkt med Cover Up - BNL124007[/url]<a href="http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124007-p-5.html">Bonishi Bikini Baddräkt med Cover Up - BNL124007</a>SEK 2,050 SEK 554Spara: 73% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124011-p-6.html]Bonishi Bikini Baddräkt med Cover Up - BNL124011[/url]<a href="http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124011-p-6.html">Bonishi Bikini Baddräkt med Cover Up - BNL124011</a>SEK 3,079 SEK 562Spara: 82% mindre<a href="http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124013-p-8.html"><div style="vertical-align: middle;height:250px"><img src="http://sv.bikinicool.top/images/_small//bikini_2/New-Arrivals/Bonishi-Bikini-Swimsuit-with-Cover-Up-BNL124013.jpg" alt="Bonishi Bikini Baddräkt med Cover Up - BNL124013" title=" Bonishi Bikini Baddräkt med Cover Up - BNL124013 " width="167" height="250" class="listingProductImage" id="listimg" /></div></a>[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124013-p-8.html]Bonishi Bikini Baddräkt med Cover Up - BNL124013[/url]SEK 1,669 SEK 571Spara: 66% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124016-p-9.html]Bonishi Bikini Baddräkt med Cover Up - BNL124016[/url]<a href="http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124016-p-9.html">Bonishi Bikini Baddräkt med Cover Up - BNL124016</a>SEK 1,401 SEK 588Spara: 58% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124017-p-7.html]Bonishi Bikini Baddräkt med Cover Up - BNL124017[/url][url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124017-p-7.html]Bonishi Bikini Baddräkt med Cover Up - BNL124017[/url]SEK 1,635 SEK 536Spara: 67% mindre<a href="http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124021-p-10.html"><div style="vertical-align: middle;height:250px"><img src="http://sv.bikinicool.top/images/_small//bikini_2/New-Arrivals/Bonishi-Bikini-Swimsuit-with-Cover-Up-BNL124021.jpg" alt="Bonishi Bikini Baddräkt med Cover Up - BNL124021" title=" Bonishi Bikini Baddräkt med Cover Up - BNL124021 " width="167" height="250" class="listingProductImage" id="listimg" /></div></a>[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124021-p-10.html]Bonishi Bikini Baddräkt med Cover Up - BNL124021[/url]SEK 1,531 SEK 580Spara: 62% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124025-p-11.html]Bonishi Bikini Baddräkt med Cover Up - BNL124025[/url][url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124025-p-11.html]Bonishi Bikini Baddräkt med Cover Up - BNL124025[/url]SEK 3,330 SEK 588Spara: 82% mindre<a href="http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124027-p-12.html"><div style="vertical-align: middle;height:250px"><img src="http://sv.bikinicool.top/images/_small//bikini_2/New-Arrivals/Bonishi-Bikini-Swimsuit-with-Cover-Up-BNL124027.jpg" alt="Bonishi Bikini Baddräkt med Cover Up - BNL124027" title=" Bonishi Bikini Baddräkt med Cover Up - BNL124027 " width="167" height="250" class="listingProductImage" id="listimg" /></div></a>[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124027-p-12.html]Bonishi Bikini Baddräkt med Cover Up - BNL124027[/url]SEK 2,024 SEK 571Spara: 72% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124035-p-13.html]Bonishi Bikini Baddräkt med Cover Up - BNL124035[/url]<a href="http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124035-p-13.html">Bonishi Bikini Baddräkt med Cover Up - BNL124035</a>SEK 1,669 SEK 588Spara: 65% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124037-p-14.html]Bonishi Bikini Baddräkt med Cover Up - BNL124037[/url][url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnl124037-p-14.html]Bonishi Bikini Baddräkt med Cover Up - BNL124037[/url]SEK 2,128 SEK 554Spara: 74% mindre<a href="http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnyf1126-p-15.html"><div style="vertical-align: middle;height:250px"><img src="http://sv.bikinicool.top/images/_small//bikini_2/New-Arrivals/Bonishi-Bikini-Swimsuit-with-Cover-Up-BNYF1126.jpg" alt="Bonishi Bikini Baddräkt med Cover Up - BNYF1126" title=" Bonishi Bikini Baddräkt med Cover Up - BNYF1126 " width="167" height="250" class="listingProductImage" id="listimg" /></div></a>[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnyf1126-p-15.html]Bonishi Bikini Baddräkt med Cover Up - BNYF1126[/url]SEK 2,188 SEK 597Spara: 73% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnyf1130-p-16.html]Bonishi Bikini Baddräkt med Cover Up - BNYF1130[/url]<a href="http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnyf1130-p-16.html">Bonishi Bikini Baddräkt med Cover Up - BNYF1130</a>SEK 1,903 SEK 605Spara: 68% mindre[url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnyl1007-p-17.html]Bonishi Bikini Baddräkt med Cover Up - BNYL1007[/url][url=http://sv.bikinicool.top/bonishi-bikini-baddr%C3%A4kt-med-cover-up-bnyl1007-p-17.html]Bonishi Bikini Baddräkt med Cover Up - BNYL1007[/url]SEK 3,200 SEK 623Spara: 81% mindre[url=http://sv.bikinicool.top/bonishi-hel-baddr%C3%A4kt-med-cover-up-bnl123010-p-21.html]Bonishi Hel baddräkt med Cover Up - BNL123010[/url][url=http://sv.bikinicool.top/bonishi-hel-baddr%C3%A4kt-med-cover-up-bnl123010-p-21.html]Bonishi Hel baddräkt med Cover Up - BNL123010[/url]SEK 2,906 SEK 580Spara: 80% mindre[url=http://sv.bikinicool.top/bonishi-monokini-med-cover-up-bn123014-p-18.html]Bonishi monokini med Cover Up - BN123014[/url]<a href="http://sv.bikinicool.top/bonishi-monokini-med-cover-up-bn123014-p-18.html">Bonishi monokini med Cover Up - BN123014</a>SEK 1,756 SEK 580Spara: 67% mindre Visar [b]1[/b] till [b]20[/b] (av [b]149[/b] produkter) 1[/b] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=2&sort=20a]2[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=3&sort=20a]3[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=4&sort=20a]4[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=5&sort=20a]5[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=6&sort=20a]...[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=8&sort=20a]8[/url] [url=http://sv.bikinicool.top/tysta-ner-c-13.html?page=2&sort=20a][Nästa >>][/url] [url=http://sv.bikinicool.top/index.php]Hem[/url] <a href="http://sv.bikinicool.top/index.php?main_page=shippinginfo">Frakt</a> [url=http://sv.bikinicool.top/index.php?main_page=Payment_Methods]Grossist[/url] [url=http://sv.bikinicool.top/index.php?main_page=shippinginfo]Försändelsespårning[/url] [url=http://sv.bikinicool.top/index.php?main_page=Coupons]kuponger[/url] [url=http://sv.bikinicool.top/index.php?main_page=Payment_Methods]Betalningsmetoder[/url] <a href="http://sv.bikinicool.top/index.php?main_page=contact_us">Kontakta oss</a>[url=http://www.coolbikinishop.com/sv/one-piece-c-1.html]One Piece Baddräkt[/url] [url=http://www.coolbikinishop.com/sv/two-piece-c-5.html]sexig bikini[/url] [url=http://www.coolbikinishop.com/sv/tankini-c-11.html]tankini Baddräkt[/url] [url=http://www.coolbikinishop.com/sv/skirtini-c-12.html]skirtini Baddräkt[/url] <a style=" font-weight:bold;" href="http://www.coolbikinishop.com/sv/bikini-amp-cover-up-set-c-14.html" target="_blank">Bikini u0026 Cover Up Set</a> [url=http://pandora.coolbikinishop.com]pandora[/url] [url=http://moncler.coolbikinishop.com]moncler[/url] [url=http://replicawatches.coolbikinishop.com]klockor[/url] [url=http://canadagoose.coolbikinishop.com]Canada Goose[/url] [url=http://sv.bikinicool.top/cover-up-c-13.html][/url]Copyright © 2012 All Rights Reserved.[b][url=http://sv.bikinicool.top/nyheter-c-10.html]nya baddräkter till salu[/url][/b][b][url=http://www.bikinicool.top/sv/nyheter-c-10.html]nya baddräkter till salu[/url][/b][url=http://cheaptiffanyco435.webs.com] coverups blog [/url]<a href="http://discountweddingdressesonline8.webs.com"> coverups </a>[url=http://WeddingDresses84.webs.com] About bikinicool.top blog [/url]
Go to Top of Page
   Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000