Query for Backup Model

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Utahduck@hotmail.com
    #1

    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,
    Utah

    Tags: None
    • KenJ
      #2
      Re: Query for Backup Model

      Hi Utah,

      Try DATABASEPROPERT YEX 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...@hotmai l.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

        Comment

        • Utahduck@hotmail.com
          #3
          Re: Query for Backup Model

          On Mar 15, 7:43 pm, "KenJ" <kenjohn...@hot mail.comwrote:
          Hi Utah,
          >
          Try DATABASEPROPERT YEX 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...@hotmai l.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!

            Comment

            Previous template Next
            Working...