Re: Recovery Model Question.

The script generates your ALTER DATABASE commands for you. Take the result of the script, paste in into a query window and execute it.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Cipher" <cipher@xxxxxxx> wrote in message news:eZOTxetZHHA.2448@xxxxxxxxxxxxxxxxxxxxxxx
First,thnx a lot guys for your support.
I run this sql script through Query Analyzer :

use master;
select 'alter database' +name+ 'set recovery simple'
from dbo.sysdatabases
where name not in('master','tempdb','msdb','model')
go

but the weird is that the script runs succefully without errors ,but it didnt make any change
to any databases!I check the recovery model and remains unfortunately full in all databases..
i dont understand..
Also because i forgot to mention it,the SQL version is SQL 2000 SP 4

Cipher.



"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message news:eVZMFxpZHHA.1400@xxxxxxxxxxxxxxxxxxxxxxx
Tibor,

I will even keep MSDB in simple recovery mode and takes the differential backup twice a day.

SELECT 'ALTER DATABASE ' + name + ' SET RECOVERY FULL'
FROM sys.databases
WHERE name NOT IN('master', 'tempdb','MSDB')

Thanks
Hari


"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in message news:eSAEbjnZHHA.5044@xxxxxxxxxxxxxxxxxxxxxxx
No version posted, assuming 2005:

Modify below to your liking, run it, take the result, tidy up and verify, and execute it.

SELECT 'ALTER DATABASE ' + name + ' SET RECOVERY FULL' FROM sys.databases
WHERE name NOT IN('master', 'tempdb')

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Morgan" <morgan@xxxxxxxxxx> wrote in message news:%23V1czMnZHHA.1400@xxxxxxxxxxxxxxxxxxxxxxx
Yes,exactly.
I want to change massive all the 200 databases recovery
model option from full to simple but i dont want to achieve this manually
because of the huge overhead.
For that reason i asked ,if theres a more quicker and better way to achive this.

Thnx a lot.
Cipher.


"Immy" <therealasianbabe@xxxxxxxxxxx> wrote in message news:%23DV67OlZHHA.348@xxxxxxxxxxxxxxxxxxxxxxx
Are you asking for a way to change this value against 200 different databases?

"Cipher" <cipher@xxxxxxx> wrote in message news:eIh22lkZHHA.4772@xxxxxxxxxxxxxxxxxxxxxxx
Hello to everyone,

I want to ask if there is a way ,maybe through a strored procedure or sql script
to change massive in 200 databases for example the recovery model from full to simple ??
If anybody has an idea or knows i will appreciate it.

Thanx a lot.
Cipher.








.

Relevant Pages

  • Re: Recovery Model Question.
    ... I run this sql script through Query Analyzer: ... to any databases!I check the recovery model and remains unfortunately full ... I want to change massive all the 200 databases recovery ...
    (microsoft.public.sqlserver.tools)
  • Script log-shipping configuration and steps for disaster recovery
    ... I am making the disaster recovery plan for the sql 2005 databases at ... of script this so I just run the script for the rest of the databases ... instead of going through the wizard 40 times. ...
    (microsoft.public.sqlserver.replication)
  • Re: MS SQL 2005 Express Edition - Replication Question
    ... What I do is to turn on "generate script" (there is a toolbar button ... I'm new to MS SQL, ... laptop, create and/or test the databases, when ready transfer the ... Something like replication? ...
    (comp.databases.ms-access)
  • Re: MS SQL 2005 Express Edition - Replication Question
    ... What I do is to turn on "generate script" (there is a toolbar button ... I'm new to MS SQL, ... laptop, create and/or test the databases, when ready transfer the ... Something like replication? ...
    (comp.databases.ms-access)
  • Re: Recovery Model Question.
    ... The script achieve a massive recovery model change! ... of the script, paste in into a query window and execute it. ... I run this sql script through Query Analyzer: ... I want to change massive all the 200 databases recovery ...
    (microsoft.public.sqlserver.tools)