-
Backup production database procedure
Greetings -
In my new job, they are using litespeed to backup all production databases. A template is setup that backs up all databases on daily basis (full backup once a day, and transactional log every 15 mins). The backp files .bak is retained for 90 days, and the trn files are retained for 7 days. Any ideas what is the standard procedure is to retain production data? I know in real world, you want to make nightly, weekly, and monthly backup then save them into another location. I am bothered by amount of files they save, this procedure is followed for test and staging as well!
Thanks,
Lava
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|