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 |
|
kpsreenath
Yak Posting Veteran
52 Posts |
 Posted - 2006-03-03 : 17:47:32
|
| Hi AllWe are in the process of changing the recovery model from simple to Full on all the production servers.I have changed all the user databases, but little sceptical about changing the master, msdb and model database which are in SQL Server 7.Is there any complication/issues which we can foresee while changing the recovery mode to full for the system databases. I googled and coudnt find any information worthwhile as its SQL Server 7.Thanks in advanceSreenathThanksSree |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-03 : 17:53:09
|
| You should not change the recovery model on system databases. I'm not even sure if it is possible. You shouldn't change them on any version of SQL Server.What is the reasoning behind this for the system databases?Tara Kizeraka tduggan |
 |
|
|
kpsreenath
Yak Posting Veteran
52 Posts |
Posted - 2006-03-05 : 15:05:54
|
| The reason behind changing the recovery model is for uniformity and to avoid any complexity like some databases in simple, some in full etc.We want all the databases to be full recovery I understand this is not a good argument in favour of changing system databases to full recovery mode, but my big boss want it to be the this way. So can you tell whats the harm in putting the system databases in full recovery mode.Please give me some valid points with which I can say that we shouldnt be changing the recovery mode for system databases.Unfortunately, I dont see any documentation in the net.ThanksSree |
|
|
|
|
|
|
Full recovery -System Databases SQL Server 7