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 |
|
soonyu
Starting Member
13 Posts |
 Posted - 2008-03-03 : 03:18:18
|
| anybody do database backup file testing ?After you backup database to tape, do you do testing on file on tape ?how frequent you do so ? and What the procedure? Cheers |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-03-03 : 17:05:20
|
| Once a month I will try to take a backup that is on tape and have it returned from off-site storage company, I will then ask our backup Admin to restore the backup files back to a disk somewhere so I can then restore the database onto another server.I go from "end to end" so that I can see not only are the backups good but so that I can get a time idea. On a weekly basis I would recommended that you restore to a different database server just to make sure you have a good copy. A lot of this can depend on your retention plan as well.Chris Shawwww.SQLonCall.com |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-04 : 01:47:20
|
| Make sure you have the process fully documented , so anyone else can run the same testsJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
Database backup testing