Re: Recovery Model Question.

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.
    ... Take the result of the script, paste in into a query window and execute it. ... I run this sql script through Query Analyzer: ... to any databases!I check the recovery model and remains unfortunately full in all databases.. ...
    (microsoft.public.sqlserver.tools)
  • Re: Update 300 DBs with .sql file
    ... -- big SQL Script here' FROM master..sysdatabases ... use a where clause to exclude databases, ... behavior of this view is changing in SQL Server 2005 and it will no longer ... > database, use that database, and execute the long string statement. ...
    (microsoft.public.sqlserver.server)
  • Re: Run an SQL Script for all User Databases
    ... DECLARE cc CURSOR FORWARD_ONLY ... EXEC master..xp_cmdshell @sql ... > Is there a way to run an SQL Script for all User Databases? ...
    (microsoft.public.sqlserver.programming)
  • Recovery for SQL Anywhere 1.0.0933
    ... Recovery for SQL Anywhere is a powerful data recovery software for ... damaged SQL Anywhere database files. ... Recovers computed fields, unique keys, primary keys, indexes, ... Recovery for SQL Anywhere recovers unencrypted databases ...
    (comp.software.shareware.announce)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)