Backups in MS SQL are really easy – if you do them.  they are frightfully difficult if you don’t do them.  We don’t backup and use DPM (MS System Center Data Protection manager) to make backups.  We will not have better recovery than the schedule of log backups, but it it all centralized and easy to take care of.  So is recovery.

The backup process normally depends on the recovery model:  ( Full, simple or bulk-logged.  With full or bulk-logged, you need to backup both the data and the transaction log.  The log is recycled each time you back it up -it will continue to grow if you do not back it up.  Simple recycles the log each time you update the data – you do not have POINT IN TIME recovery to earlier versions with the simple model.

From SSMS, issue these commands

BACKUP DATABASE AdventureWorks TO DISK = 'C:\AdventureWorks.BAK'


BACKUP LOG AdventureWorks TO DISK = 'C:\AdventureWorks.TRN'
This entry was posted in Uncategorized. Bookmark the permalink.