Change recovery model

I can't change the recovery model from full to simple on one of my SQL 2000
server databases. I can change it for the other user databases but just not
the one I want to change. Any idea how to fix this problem?
Thanks,
Gracie
What happens when you try to change it? And how are you doing that? Any
error messages?
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"gracie" <gracie@.discussions.microsoft.com> wrote in message
news:1A5B440C-1163-40C6-A312-B7B467FC4095@.microsoft.com...
> I can't change the recovery model from full to simple on one of my SQL
2000
> server databases. I can change it for the other user databases but just
not
> the one I want to change. Any idea how to fix this problem?
> Thanks,
> Gracie
|||What error message do you get?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"gracie" <gracie@.discussions.microsoft.com> wrote in message
news:1A5B440C-1163-40C6-A312-B7B467FC4095@.microsoft.com...
I can't change the recovery model from full to simple on one of my SQL 2000
server databases. I can change it for the other user databases but just not
the one I want to change. Any idea how to fix this problem?
Thanks,
Gracie
|||I'm trying it through EM. Not error msg the ok button is greyed out/
"Tom Moreau" wrote:

> What error message do you get?
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "gracie" <gracie@.discussions.microsoft.com> wrote in message
> news:1A5B440C-1163-40C6-A312-B7B467FC4095@.microsoft.com...
> I can't change the recovery model from full to simple on one of my SQL 2000
> server databases. I can change it for the other user databases but just not
> the one I want to change. Any idea how to fix this problem?
> Thanks,
> Gracie
>
|||Try running it through QA with an ALTER DATABASE. Also, are you a member of
the appropriate roles?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"gracie" <gracie@.discussions.microsoft.com> wrote in message
news:06E1EDD1-27D4-4C12-B652-037B9B220A5B@.microsoft.com...
I'm trying it through EM. Not error msg the ok button is greyed out/
"Tom Moreau" wrote:

> What error message do you get?
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "gracie" <gracie@.discussions.microsoft.com> wrote in message
> news:1A5B440C-1163-40C6-A312-B7B467FC4095@.microsoft.com...
> I can't change the recovery model from full to simple on one of my SQL
2000
> server databases. I can change it for the other user databases but just
not
> the one I want to change. Any idea how to fix this problem?
> Thanks,
> Gracie
>
|||Use Query Analyzer
ALTER DATABASE databasename SET RECOVERY SIMPLE
If this doesn't work, tell us what error you get...
http://www.aspfaq.com/
(Reverse address to reply.)
"gracie" <gracie@.discussions.microsoft.com> wrote in message
news:06E1EDD1-27D4-4C12-B652-037B9B220A5B@.microsoft.com...[vbcol=seagreen]
> I'm trying it through EM. Not error msg the ok button is greyed out/
> "Tom Moreau" wrote:
2000[vbcol=seagreen]
not[vbcol=seagreen]
|||Worked, thanks!
"Aaron [SQL Server MVP]" wrote:

> Use Query Analyzer
> ALTER DATABASE databasename SET RECOVERY SIMPLE
> If this doesn't work, tell us what error you get...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "gracie" <gracie@.discussions.microsoft.com> wrote in message
> news:06E1EDD1-27D4-4C12-B652-037B9B220A5B@.microsoft.com...
> 2000
> not
>
>