My SQL and windows tips and tricks blog where I collect things that I use in my regular work as domain admin and dba and things that can be useful some day.
fredagen den 15:e januari 2010
Check database recovery model
A small script to check the database recovery model. Can be handy sometime.
SELECT name, databasepropertyex (name,'Recovery') FROM master..sysdatabases
0 kommentarer:
Skicka en kommentar