In SSMS, right-click the database and select Tasks > Back Up. Select the Files and filegroups option. Select the files and filegroups that you want to back up and press OK. How to Create a File or ...

As I have recently discovered though, you can use a PowerShell script to back up a SQL Server Express database. Before I show you how to perform such a backup, there are a few things that you ...

Continuous archiving is closest to the basic SQL Server backup/restore process. ... but running the create function script in a subsequent database connection has resolved the issue.