Posts Tagged ‘SQL Server’

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 tried it and it worked. USE DBNAME GO ALTER DATABASE DBNAME SET RECOVERY SIMPLE WITH […]

Oct 27th, 2012 | Filed under Windoze

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 for more details. It worked for my database and I was able to repair successfully.

Aug 13th, 2012 | Filed under Windoze