Home   Wordpress   Log in

Archive for January, 2009

How to Find SQL Databases in SIMPLE Recovery Model

January 23rd, 2009 by admin | No Comments | Filed in Database, Design

Very simple…

SQL 2000

USE master
GO

SELECT catalog_name
FROM information_schema.schemata
WHERE DATABASEPROPERTYEX(catalog_name,'RECOVERY') = 'SIMPLE' ;

 

SQL 2005-2008


USE master
GO

SELECT name
FROM sys.databases
WHERE recovery_model_desc = 'SIMPLE'
Download Full Movie Online Hytrin Astérix le Gaulois download movie Close Encounters of the Third Kind download movie Ginger Snaps: Unleashed download movie Back to the Future Part II download movie Awakenings download movie Electric Dreams download movie The Crow: Salvation download movie Tarnation download movie Soleil rouge download movie Darkman download movie Whirlwind download movie The hunchback download movie Life stinks download movie Charlie s angels: full throttle download movie Man to man download movie Music and lyrics download movie