Monthly Archives: September 2010

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 →

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 →