Create a backup in SSMS and Script Action to job option ... Alternatively, you can use the T-SQL commands to restore a database file or filegroup. RESTORE DATABASE [Northwind] FILE = N'Northwind' FROM ...

SQL Server lets you disconnect a database from the main server program, allowing you to make safe backup copies or send data to branch offices. Once you disconnect a database, you must restore it ...