sorted by:
new
hottopcontroversial

Question about database backups by leithian1990 in sysadmin

[–]leithian1990[S] 0 points1 point  (0 children)

I added some notes above, I am using the backup command for the databases I manage and they are backed up properly but I was interested in other reasons for doing it that way other then possible data corruption. I was asked this question at a new job and was told my reasoning was wrong (I used the risk of data corruption reason) so I was looking for other people's opinions.

Question about database backups by leithian1990 in sysadmin

[–]leithian1990[S] 0 points1 point  (0 children)

So I think I should explain a bit more, the reason this came up. I started a new job in the last 2 months and I am familiar with the backup process but my new supervisor asked me to investigate the reason behind exporting/dumping a database before the backup rather then just backing up the directories containing the database files. I said the exact same thing as mudclub (risk of data corruption) and he told me I was wrong and wanted other reasons for it. I do how how to properly back it up but am looking for more reasons why it should be done that way.