How to Create Full Database Backup Using T-SQL. If you want to automate the backup, ... you can use the T-SQL commands to create files or filegroups backup. BACKUP DATABASE [Northwind] FILEGROUP = ...

The next step is to create a server to host your SQL database. In the Server section, click the button to Create a new Server. On the creation screen ( Figure C ), give the server a name, pick a ...