This code is used to add a new log file to the database using the alter database command. Method 2-Recover Database from an Existing Backup If you fail to rebuild the corrupted Log files, then you can ...

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

Once I have my log file name, I can use the DBCC command to shrink the file. In the following command I try to shrink my log file down to 1GB. DBCC SHRINKFILE (‘SalesHistory_Log’, 1000) ...

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.