How frequently should sys databases be backed up?
currently allof my user databases have a weekly full and then a daily differential backup job running and are being managed by a maintenance plan in management studio. The four sys databases are also grouped into these backups so the actual setting in the back up job is "all databases" on the full and the differentials
my question is this.
would I be ok taking out the sys databases of the differential backups and only back them up in the weekly full?
master
model
msdb
tempdb
these are the 4 in question.
my question is this.
would I be ok taking out the sys databases of the differential backups and only back them up in the weekly full?
master
model
msdb
tempdb
these are the 4 in question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how long should I keep these backups?
I would assume I need to have a master backup coinciding with my restore point.
lets say I have two databases.
apple
orange
I need to restore apple to a point in time 2 days ago. 3 pm Jan24
orange is in good shape
would I need to restore master to a previous backup? or would the current master be just fine
I assuming the present master would be fine.
second scenario
I lose my whole sql server and have multiple backups of master and orange and apple
I want to restore the database server to a point in time of jan 25th
would I need to correspond the proper master restore with the versions of orange?
also... will the master work with different versions of sql server?
trashed sql server 2008 and restore on top of 2012
thanks a bunch!