If you want to automate the backup, you can use the T-SQL code. T-SQL is the SQL Server language used to automate SQL Server tasks. The following example shows how to create a Full Backup using T-SQL.

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

A free tool from Microsoft can make backing up data in Windows Server 2008 R2 efficient and almost hassle-free. Here's how to use it effectively. Back in the day, Microsoft's free backup tool was ...

A new online index-rebuild feature is designed to reduce the need for DBAs to take the database ... the need to shut SQL Server servers down and then power them back up when things arent working ...

You could probably pump the data right into SQL directly. We use linked servers in SQL Server 2000 (I know...) to pump data from an AS400 running DB2 in to some tables in SQL Server to do analysis.