Arrow icon used with Back to Top link[Top]
Using PowerShell
    Use the Backup-SqlDatabase cmdlet. To explicitly indicate that this is a full database backup, specify the -BackupAction parameter with its default value, Database. This parameter is optional for full database backups.
    The following example creates a full database backup of the MyDB database to the default backup location of the server instance Computer\Instance. Optionally, this example specifies -BackupAction Database.
    --Enter this command at the PowerShell command prompt, C:\PS>
    Backup-SqlDatabase -ServerInstance Computer\Instance -Database MyDB -BackupAction Database
To set up and use the SQL Server PowerShell provider
    SQL Server PowerShell Provider