which files to backup in sql 2008
Posted on 2011-09-05
in our accounting software which runs sql 2008, we were told to backup the 2 files in data directory of sql. One is called 001.mdf which is company data itself and also 001_log.ldf which is the log file relating to that company. The 001.mdf is 62gig but the 001_log.ldf is 260gig! We run full backup of bak files that are backed up from sql itself but wanted to know how to back up log file within sql studio manager and if it is necessary since we are running backup of 001.mdf already. Any ideas on how to streamline process since log file seems so big to backup. Is log file same as transaction file which has .trn exetension? thanks.