Backup-SqlDatabase (SQLServer) - SQL Server PowerShell

The Backup-SqlDatabase cmdlet performs backup operations on a SQL Server database. This includes full database backups, transaction log backups, and database file backups. This cmdlet is modeled after the Microsoft.SqlServer.Management.Smo.Backup class. The parameters on this class generally correspond to properties on that Smo object. To back up a database by server instance path and database name, specify the server instance path in the Path parameter and the database name in the Database parameter. To back up a database using an Smo.Server object and database name, specify the Smo.Server object in the InputObject parameter, either directly or by using the pipeline operator, and the database name in the Database parameter. To back up a database by server instance and database name, specify the server instance in the ServerInstance parameter and the database name in the Database parameter. To back up a database using an Smo.Database object, specify the Smo.Database object in the DatabaseObject parameter, either directly or by using the pipeline operator. By default this cmdlet performs a full database backup. Set the type of the backup by using the BackupAction parameter. By default the backup file is stored in the default server backup location under the name databasename.bak for full and/or file backups and under the name databasename.trn for log backups. To specify a different file name, use the BackupFile parameter. To specify a backup file location and use an auto-generated file name, specify the location by using the BackupContainer parameter.