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 |
|
spepi
Starting Member
17 Posts |
 Posted - 2005-06-24 : 15:28:45
|
| I have a DB in my production env. that we would like to back up the transaction logs, but the DB is currently in "Simple Mode"Will there be any effects if I change it to "Bulk or Full mode"Do I need to restart SQL or any other services?thanksScott in MA |
|
|
Crito
Starting Member
40 Posts |
Posted - 2005-06-24 : 15:45:05
|
| Bulk copies are non-logged operations. So while it won't truncate the log automatically (as "simple" does) you may or may not be able to use your log dumps for recovery purposes.Anyway, just perform a full backup after making the change and watch the transaction log size to make sure it doesn't fill up the disk (or don't let it autogrow)... and if it does get huge that means you need to dump the trans log more frequently, not go back to the simple recovery model, as many of my clients seem to do. :o----------------------------------Gun for hire, have horse, will travel. |
 |
|
|
spepi
Starting Member
17 Posts |
Posted - 2005-06-24 : 15:49:07
|
| what would be a good template to use to dump the data? Every 4 hours purge? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-24 : 15:50:46
|
| Just change the recovery model. Now start performing tlog backups. We do ours every 15 minutes due to the criticality of the data.Tara |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-06-29 : 01:30:42
|
quote:
Originally posted by spepi
what would be a good template to use to dump the data? Every 4 hours purge?
it depends, you can perform a scheduled routine backup or an alert for log file space used which will trigger a backup log or truncate the log depending on your recovery requirement whenever it reaches a certain level--------------------keeping it simple... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-29 : 12:42:52
|
| I would NOT recommend ever truncating the log unless the tlog is completely full AND you've run out of disk space. This should always be a manual step and not one that is automated as it invalidates the tlog chain. If you think you need to do this, then you should not be using FULL recovery model.Tara |
|
|
|
|
|
|
Simple to Full Backup