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 |
|
rosejr
Starting Member
12 Posts |
 Posted - 2009-02-09 : 12:16:19
|
| How how backups would you recommend to keep on disk and why? I have a client that only wants to keep 1 night's backup on disk, and I've explained that this could cause problems with recovery time as we could have to go to tape. Does anyone have other reasons? I'm trying to learn best practices.Thanks in advance for any responses. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-09 : 12:42:47
|
| Why don't you Transfer old backups to Tape as soon as new backup is successfully completed? What is recovery model of database? Don't you need point in time recovery. |
 |
|
|
jason.williams14
Starting Member
10 Posts |
Posted - 2009-02-09 : 20:28:41
|
| If he insists on keeping last nights backup to disk, can you keep it on disk and put it to tape as well?I never try to keep my backups on local disks. To risky with potential hardware failures (they happen.)Instead, I have a share mounted to our servers that I push the backups to. Our Netbackup piece then comes through and grabs the backups from the share and writes them to tape.HTH |
|
|
|
|
|
|
Backup Strategy question.