Posted by Utahduck on 03/16/07 14:30

On Mar 15, 7:43 pm, "KenJ" <kenjohn...@hotmail.com> wrote:
> 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:
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

That could not have been more perfect. THANK YOU!

[Back to original message]