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...
>
>

Change name of exported csv file

Hi guys,
I have created a report with Reporting Services 2005 that gets executed according to a schedule I have created, every working date and the output gets exported to a csv file. My problem is that I want the exported file to have the running date append to it, e.g. report "Myrep" gets exported as "Myrep.csv" but I want to have it as "Myrep070607.csv"

Thanks in advanceHi
pzou
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.

It will help Experts in the forum in solving/underestanding your problem in a better way.|||Is it in ms.net

please clarify.