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 |
|
leodone
Starting Member
30 Posts |
 Posted - 2009-10-28 : 10:01:29
|
| We have several databases that are Simple database, we would like to change them to FULL. I would like to know if there would be a problem on changing these database from SIMPLE to FULL? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-28 : 10:37:25
|
You have to consider that the transaction log for a database in full recovery model will grow and grow and grow without issuing regularly scheduled transaction log backups.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
leodone
Starting Member
30 Posts |
Posted - 2009-10-28 : 10:48:56
|
| Thank you for the additional info about trans logs. So are you saying it is not a problem changing those databases from SIMPLE to FULL? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-28 : 11:01:55
|
I am not a dba, but I have done that before many times without any known problems.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-28 : 11:57:06
|
| there's no problem changing recovery models.just remember as fred said, that if you're going to full (or bulk-logged) you need to take transaction log backups |
|
|
|
leodone
Starting Member
30 Posts |
Posted - 2009-10-28 : 13:51:44
|
| Thank you everyone for your input. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-28 : 13:53:41
|
welcome 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Changing SQL database from Simple to FULL