Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
keithc
Starting Member
35 Posts |
 Posted - 2005-07-22 : 10:26:45
|
| Hi, working with Kronos and the way they have the DB backup set for the Kronos database is that the backup copies to local folder then batch file executes which then moves the backup off to a mapped drive. From there ntbackup is used to backup that folder to DLT tape drive. The DB datafiles consist of Primary and like 7 secondary filegroups, I have added the size of all the Filegroups which does correspond to the size of the backup file. The concern I have is this DB is set to full recovery model and the Transaction Log file size is at 8gig and this file is not included in the backup and is just sitting local on the server. Should this file be backed up as well and if so why. Thanks |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-22 : 11:58:44
|
| If you want to recover to a point in time or to the point failure, you need to be doing some BACKUP LOG's and hopefully the log files are on a seperate disk from your data files. If you do not do this, you can only restore to the point of the last database backup. If your log files and database files are on the same drive and you lose that drive you also lose the ability to restore to a point in time.In this backup scheme, are you creating .bak files through sql server?Please without delay go to sql server books online, open the contents tab, Administering SQL Server, and read the entire section on Backing Up and Restoring Databases. THIS IS THE MOST IMPORTANT THING ANY DBA CAN READ.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
 |
|
|
|
|
|
Backup Question