Is it advisable to take the full/complete backup only in MASTER DB ? if yes why ? if no why ?

Question

Post reply

Is it advisable to take the full/complete backup only in MASTER DB ? if yes why ? if no why ?

Pradeep Kumar Satapathy

Valued Member

Points: 59
More actions
November 15, 2006 at 7:22 am

#114195

Is it advisable to take the full/complete back up in MASTER DB ? If yes why ? If no why ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Let me ask you this. How do you plan to restore the master DB if you don't have a full backup?

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 2

master database is used mainly for security. If you do not have any change in this server, you may not backup this database every day. But you should backup this database after adding, removing, modifying this database, or after applying a new service pack or hot fix.