MS SQL Backup Script
There are many ways to backup sql script. There are many post, articles talking about backup sql.
Here is one of the quick way to backup your MS SQL Database.
1. Clear Log
TO reduce rubbish on your drive. You do not need rubbish log.
2. Backup database after clear database log.
You may put this script into your scheduler. Just change a little of the script. :)
DBCC SHRINKDATABASE (N'IT_Medan', 0,TRUNCATEONLY)
-- BACKUP DABATABASE
BACKUP DATABASE [IT_Medan_DB] TO DISK = N'C:\Backup\IT_Medan.bk' WITH INIT , NOUNLOAD , NAME = N'IT_Medanbackup', NOSKIP , STATS = 10, NOFORMAT