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