Next you need a batch script to execute the ftp commands: ftp -s: ... the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

How to Restore Files and Filegroups Using T-SQL. Alternatively, you can use the T-SQL commands to restore a database file or filegroup. RESTORE DATABASE [Northwind] FILE = N'Northwind' FROM DISK = N'C ...

However, it does not restore the Transaction logs, Allocation pages, Page 0 of all data files (the file boot page), Page 1:9 (the database boot page), and Full-text catalog. Here is the T-SQL command ...