Custom Search

Thursday, October 4, 2007

MS SQL Backup Script

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. :)

--CLEAR LOG
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

No comments: