Search code examples
sql-serversql-query-store

Create backup from database with query in ORM


How I can create a backup from my Sql database with sqlQuery or another methods (in ORM)? actually I have this Query but I can't use that in ORM


Solution

  • You can use BACKUP:

    --Backing Up a Whole Database   
    BACKUP DATABASE { database_name | @database_name_var }   
      TO <backup_device> [ ,...n ]   
      [ <MIRROR TO clause> ] [ next-mirror-to ]  
      [ WITH { DIFFERENTIAL 
               | <general_WITH_options> [ ,...n ] } ]  
    [;]