Query for Backup Model

I'm trying to write some T-SQL code for adding some fills and thrills
to backups but ran into a snag. Is there a way to query what backup
model a database is using? I can see it if I right click a database,
go to properties, select the options tab, and then can see the current
model (full, bulk-logged, and simple) but I would need to hard code
each database. In the spirit of automation, I'd rather query for the
type and then work around that instead. But I've been all over the
master database and can't seem to find any field that will indicate
the backup type.

Any guru's out there that can point me in the right direction?

Thanks,
UtahHi Utah,

Try DATABASEPROPERTYEX in Books Online: http://msdn2.microsoft.com/en-us/library/ms186823.aspx
You'll want the Recovery property.

Thanks,

KenJ

On Mar 15, 5:45 pm, Utahd...@.hotmail.com wrote:

Quote:

Originally Posted by

I'm trying to write some T-SQL code for adding some fills and thrills
to backups but ran into a snag. Is there a way to query what backup
model a database is using? I can see it if I right click a database,
go to properties, select the options tab, and then can see the current
model (full, bulk-logged, and simple) but I would need to hard code
each database. In the spirit of automation, I'd rather query for the
type and then work around that instead. But I've been all over the
master database and can't seem to find any field that will indicate
the backup type.
>
Any guru's out there that can point me in the right direction?
>
Thanks,
Utah

|||On Mar 15, 7:43 pm, "KenJ" <kenjohn...@.hotmail.comwrote:

Quote:

Originally Posted by

Hi Utah,
>
Try DATABASEPROPERTYEX in Books Online:http://msdn2.microsoft.com/en-us/library/ms186823.aspx
>
You'll want the Recovery property.
>
Thanks,
>
KenJ
>
On Mar 15, 5:45 pm, Utahd...@.hotmail.com wrote:
>
>
>

Quote:

Originally Posted by

I'm trying to write some T-SQL code for adding some fills and thrills
to backups but ran into a snag. Is there a way to query what backup
model a database is using? I can see it if I right click a database,
go to properties, select the options tab, and then can see the current
model (full, bulk-logged, and simple) but I would need to hard code
each database. In the spirit of automation, I'd rather query for the
type and then work around that instead. But I've been all over the
master database and can't seem to find any field that will indicate
the backup type.

>

Quote:

Originally Posted by

Any guru's out there that can point me in the right direction?

>

Quote:

Originally Posted by

Thanks,
Utah- Hide quoted text -

>
- Show quoted text -

That could not have been more perfect. THANK YOU!