SQL Server offers two ways to attach the .MDF file: via the Management Studio program's graphical interface or through typed Transact-SQL text commands. Start SQL Server Management Studio Click ...

You can save a backup of your MS SQL databases to a single file on your hard drive. These backup files have names ending with the ".bak" file extension, and you use them to restore database ...

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 ...

Save that batch script with a .bat extension, like GetCSV.bat. Executing that batch script will open up an ftp connection and fire off your commands resulting in filename.csv being downloaded.

In the following command I try to shrink my log file down to 1GB. DBCC SHRINKFILE (‘SalesHistory_Log’, 1000) Also, make sure that your databases are NOT set to auto-shrink.