Sunday, May 28, 2017

SQL Server 2005 msdb suspect

Assalamu'alaikum.

Hari ini ada salah satu server yang mengalami kerusakan databasenya.
Salah satu database system yaitu msdb mengalami suspect.

Coba browsing ketemu ini : https://www.mssqltips.com/sqlservertip/3191/how-to-recover-a-suspect-msdb-database-in-sql-server/

Langsung coba restore pakai plan B

USE [master]
GO
RESTORE DATABASE [msdb] 
FROM  DISK = N'C:\msdb.bak' -- lokasi file back up di C:\
WITH  FILE = 1,  
NOUNLOAD,  
REPLACE
GO

===========================================================================

Processed 1296 pages for database 'msdb', file 'MSDBData' on file 1.
Processed 4 pages for database 'msdb', file 'MSDBLog' on file 1.
RESTORE DATABASE succesfully processed 1300 pages in 0.131 seconds (81.294 MB/sec).

Alhamdulillah bisa di restore. SQL Server kembali normal

No comments:

Post a Comment

 
Search Engine Optimization and SEO Tools