Recover corrupted Database in SQL Server 2000

Recover from a corrupted Database in SQL Server 2000

This is a useful article or not I don’t know, but when your database is corrupted then this article helps you a lot.

Make sure that the database being restored is from the same Product level as the server you are restoring to. I once faced an issue when trying to restore a database from an SP4 to a non-SP4 database server.

1. Detach the corrupted MDF from Enterprise Manager.

2. Save the corrupted MDF to a safe location.

3. Now create a new database with the same name (the location must be the same as the ‘corrupted MDF and LDF’)

4. Stop the SQL Server service.

5. Now replace this MDF and LDF (New database) with the ‘corrupted MDF and LDF’

6. Start SQL Server service.

7. Launch Enterprise Manager. Now you should be able to see the database in suspect mode.

8. Launch Query Analyzer and select the master database. Issue the following commands in this order:

Order 1:
sp_configure ‘allow updates’, 1
go

Order 2:
reconfigure with override
go

9. You can now make changes to the system catalog tables.

10. Now to check the status of our database. Issue the following command
select status from sysdatabases where name’ your databae name’ (replace with your database name)
NOTE: remember the status code

11. Now execute the following command:
update sysdatabases
set status=32768 where name=’your database name’

12. Next restart SQL Server Service.

13. You will now be in Emergency Mode.

14. Now create a destination recovery database, called dbrecover and try to push data from the corrupt database to the new dbrecover database using DTS.

15. Now issue the following undocumented command:
DBCC rebuild_log(‘your database name’, ‘new log filename with path’)
àDBCC rebuild_log ('neptune', 'D:\MSSQL2000\MSSQL\Data\test_log.ldf')

16. After this successful execution, you will need to get into your database, so issue the following commands:

Step 1:
Use master
go

sp_dboption ‘your database name’, ‘single_user’, ‘true’
go

Step 2:
Use master
go

DBCC CHECKDB(‘your database name’, REPAIR_ALLOW_DATA_LOSS)
go

17. Finally set your database back to a normal status by issuing the following command:
Step 1:
Use master
go

update sysdatabase
set status=0 where name=’your database name’
go

18. Now you can see that your database is back online.

19. As a precautionary measure, please disable updates the sysem catalogs immediately by issuing the following command:
Step 1:
Use master
go

sp_configure ‘allow update’, 0
go

Step 2:
Use master
go

Reconfigure with override
go


This is how one recovers a corrupted mdf database and brings it back online.

OUG - 豆豆屋素食料理

坐落于舊巴生路5哩的“豆豆屋素食料理”，是一班年輕人為了推動環保，鼓勵更多人吃素所開設。


Dumpling ramen

Fissa Burger

Foldover

Red Sea (Spaghetti)

Maradona (Passion Fruit and Dragon Fruit)

Beauty and The beast (Mango Smoothies)

地址：91, Jalan Mega Mendung, Batu 5 Jalan Klang Lama, 58200 Kuala Lumpur
電話：03 – 7987 3318
營業時間：-
網站: -

Saterfront - Kay's Garden

地址：FF-06, First Floor, The Waterfront @ Parkcity 5, Persiaran Residen, Desa ParkCity, 52200 Kuala Lumpur, Malaysia.

電話：03 – 6280 4831

Tropicana City - KIMCHI

地址：L1-57, 1st Floor, Tropicana City Mall, No 3, Jalan SS20/27, 47400 Petaling Jaya, selangor.

電話：03- 7729 9643
網站：info@kimchi.com.my

蒲種 - Loving Hut

為了環保與健康，陳健發、黃繡湞及行銷顧問余繡琳都自稱是“吃草”的人（素食者），同時要為“草沒味”的素食刻板印象作平反！

持素超過30年的陳健發認為，5種黑、青、白、黃及紅色蔬菜可以滋養五臟，即分別滋養腎、肝、肺、脾及心臟，只要吃得均衡，絕對不會造成營養不良，反而是現代人壓力大，導致出現未老先衰的情況。

現代人必須吃得健康、多樣化及接近自然，以免年少得“痣”。現在，素食風氣漸盛，食物變得更多樣化，“找吃”也比較容易。此外，素食的大前提，也已經從吃出健康變成環保

Au Lac Salad Rool (RM 4.80)

Pumking Soup (RM 5.80)

Creamy Mushroom Soup (RM5.80)

营养粥 (RM6.80)

Chinese Stew Noodle Soup (RM7.80)

三杯排饭 (RM 9.80)

飲食習慣以植物為主

這裡使用的“蔬食”概念，是以植物為主的飲食習慣，不采用乳制品及雞蛋。此外，在LovingHut也堅持使用果糖、黃糖、海鹽及橄欖油為食物調味。

陳健發特別推薦松子糙米香飯、紅燒面、漫波排、紐約排飯、壽司等，還有香濃的蘑菇與金瓜湯，也是這裡的特選菜肴。

關心全球的暖化現象，拯救地球，到LovingHut來“蔬”食一下吧。

地址：15, Jalan Puteri 2/7,Bandar Puteri Puchong,47100 Puchong, Selangor.

電話：03-8062 7196

營業時間：上午11時至晚上10時

網站：www.lovinghut.com