change recovery mode

Hi Guys,
If I change recovery mode from full to simple, do I need to reboot computer
or re-start database? Thanks
Hello,
No need to do a SQL Server service restart or machine restart for this.
After changing the recovery model; just disable Transaction log backup, this
is because in SIMPLE rcovery model log
backup is not possible.
But if you do the otherway from SIMPLE to FULL recove then to regroup the
backup chnain you will need to do a full backup and then schedule the
transaction log backup.
Thanks
Hari
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A24DB4EE-E8E0-4CF9-B651-9BD445A7C7F4@.microsoft.com...
> Hi Guys,
> If I change recovery mode from full to simple, do I need to reboot
> computer
> or re-start database? Thanks
>
|||Thank you guys.
"Hari Prasad" wrote:

> Hello,
> No need to do a SQL Server service restart or machine restart for this.
> After changing the recovery model; just disable Transaction log backup, this
> is because in SIMPLE rcovery model log
> backup is not possible.
> But if you do the otherway from SIMPLE to FULL recove then to regroup the
> backup chnain you will need to do a full backup and then schedule the
> transaction log backup.
> Thanks
> Hari
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:A24DB4EE-E8E0-4CF9-B651-9BD445A7C7F4@.microsoft.com...
>
>

change recovery mode

Hi Guys,
If I change recovery mode from full to simple, do I need to reboot computer
or re-start database? ThanksNope..
VT
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A24DB4EE-E8E0-4CF9-B651-9BD445A7C7F4@.microsoft.com...
> Hi Guys,
> If I change recovery mode from full to simple, do I need to reboot
> computer
> or re-start database? Thanks
>|||Hello,
No need to do a SQL Server service restart or machine restart for this.
After changing the recovery model; just disable Transaction log backup, this
is because in SIMPLE rcovery model log
backup is not possible.
But if you do the otherway from SIMPLE to FULL recove then to regroup the
backup chnain you will need to do a full backup and then schedule the
transaction log backup.
Thanks
Hari
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A24DB4EE-E8E0-4CF9-B651-9BD445A7C7F4@.microsoft.com...
> Hi Guys,
> If I change recovery mode from full to simple, do I need to reboot
> computer
> or re-start database? Thanks
>|||Thank you guys.
"Hari Prasad" wrote:

> Hello,
> No need to do a SQL Server service restart or machine restart for this.
> After changing the recovery model; just disable Transaction log backup, th
is
> is because in SIMPLE rcovery model log
> backup is not possible.
> But if you do the otherway from SIMPLE to FULL recove then to regroup t
he
> backup chnain you will need to do a full backup and then schedule the
> transaction log backup.
> Thanks
> Hari
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:A24DB4EE-E8E0-4CF9-B651-9BD445A7C7F4@.microsoft.com...
>
>