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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Changing SQL database from Simple to FULL

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.
Go to Top of Page

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?
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

leodone
Starting Member

30 Posts

Posted - 2009-10-28 : 13:51:44
Thank you everyone for your input.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -