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 |
|
cornall
Posting Yak Master
148 Posts |
 Posted - 2008-07-17 : 06:47:18
|
| Hi,Is there any danger of setting the recovery mode to simple if we are doing no log shipping and the transaction log is truncated every night anyway?Cheers D |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-07-17 : 07:04:34
|
| it depends how crucial your data is? if you need to restore from a backup tomorrow will you get sacked coz you can't give them anything more recent that the last full backup?Em |
 |
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2008-07-17 : 07:36:32
|
| well we aren't shipping the logs anywhere so if the server went bang all we could give is last nights backup anyway. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 23:54:35
|
| But you can backup log to remote location with full backup, otherwise how to get last nights backup. |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-07-21 : 11:05:27
|
| You can take Diff. backup as well to make it bit easier for your Job.ManojMCP, MCTS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-21 : 22:45:29
|
| Still should put backup files on remote location. |
|
|
|
|
|
|
Recover Mode