Skip to content

Yuniawan Tri Cahyono Posts

e-Book Gratis buat baca sambil ngopi

7 Free .NET Development and Architecture E-books Foundations Of Programming Microsoft Application Architecture Guide, 2nd Edition Rob Miles C# Yellow Book 2010 Threading in C# Improving .NET Application Performance and Scalability Applying Design Patterns RefCardz from DZone

Cara Restore SQL Server 2005 Suspect Database

Kadang kala kita menjumpai masalah di sql server 2005 salah satu database kita ada suspect mode, akan tetapi database yang lain harus tetep jalan saya coba langkah dibawah ini ternyata berhasil, anda mempunyai masalah yang sama? selamat mencoba

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