Indra Permana indrapermana

🏠

Working from home

GUI lover

indrapermana / fix-recover-pending.sql

Created November 4, 2019 04:49

sql server fix recovery pending

	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

indrapermana / script.sql

Created October 15, 2019 03:02

repair database recovery pending

ALTER DATABASE [database_name] SET ONLINE;

indrapermana / ubuntu stop apache2 and start xampp

Created October 30, 2017 11:06

	sudo /etc/init.d/apache2 stop
	sudo /opt/lampp/lampp start

indrapermana / remove_folder.txt

Created October 2, 2017 06:02

Remove folder from git repository

	#add [folder name] to .gitignore file

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