Monthly Archives: September 2010

Automating SQL Server Backups

These instructions are assuming you have already created the database -this is using SqlServer 2008, there will be modifications added later for SqlServer 2003 changes Step 1 – Set up Folders a. Add a folder called ‘DBBackupFTP’ in the ftp … Continue reading

Posted in Sql Server | Leave a comment

Truncating SQL Server Log Files

It has been frequently seen in SQL Server, that despite the efforts of the DBAs, the Log Files will refuse to be truncated. However, the following snippet of T-SQL is most effective on it’s own. USE┬áDatabaseName GO DBCC SHRINKFILE(TransactionLogName, 1) … Continue reading

Posted in Sql Server | Leave a comment