SQL Server – Making Life Simple

Shrink transaction log SQL 2008 r2

Posted on October 27, 2012 by lalit — No Comments ↓

Once transaction log is full, I was unable to shrink it. All searches in Google did not help. Finally I found a script which clears the transaction log if and only if the transaction log is not full yet. I Continue reading Shrink transaction log SQL 2008 r2→

SQL Server 2008 R2 (Suspect) mode – how to repair?

Posted on August 13, 2012 by lalit — No Comments ↓

Run the following SQL statements to fix the issue: 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 Please see here Continue reading SQL Server 2008 R2 (Suspect) mode – how to repair?→