Indra Permana indrapermana

## fix-recover-pending.sql
ALTER DATABASE [DB_NAME] SET EMERGENCY;
GO
ALTER DATABASE [DB_NAME] set single_user;
GO
DBCC CHECKDB ([DB_NAME], REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;
GO
ALTER DATABASE [DB_NAME] set multi_user;
GO

## script.sql
ALTER DATABASE [database_name] SET ONLINE;

## ubuntu stop apache2 and start xampp
sudo /etc/init.d/apache2 stop
sudo /opt/lampp/lampp start

## remove_folder.txt
#add [folder name] to .gitignore file

git rm -r --cached [folder name]
git commit -m 'Removing the folder for ignored!'
git push origin master
	ALTER DATABASE [DB_NAME] SET EMERGENCY;
	GO
	ALTER DATABASE [DB_NAME] set single_user;
	GO
	DBCC CHECKDB ([DB_NAME], REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;
	GO
	ALTER DATABASE [DB_NAME] set multi_user;
	GO
	#add [folder name] to .gitignore file

	git rm -r --cached [folder name]
	git commit -m 'Removing the folder for ignored!'
	git push origin master