kpaste.net RSS- Suspect durumuna düşmüş bir SQL Server veritabanınızı; veri kayıplarını da gözönüne alarak aşağıdaki komutları ard arda çalıştırarak kurtarabilirsiniz:
- EXEC SP_RESETSTATUS 'VeritabaniAdi';
- ALTER DATABASE VeritabaniAdi SET EMERGENCY
- DBCC CHECKDB('VeritabaniAdi')
- ALTER DATABASE VeritabaniAdi SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- DBCC CHECKDB ('VeritabaniAdi', REPAIR_ALLOW_DATA_LOSS)
- ALTER DATABASE VeritabaniAdi SET MULTI_USER
- T-SQL Kod Kaynağı: CodeProject
- http://www.codeproject.com/KB/reporting-services/SQL_2005_Suspect_Database.aspx
- 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
sql recovery
Posted by pi511 on Mon 3rd May 2010 19:38
raw | new post
view followups (newest first): sql recovery by pi511
Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.