Trucate Transaction Log in SQL Server 2000/2005

In SQL Server, it is important to keep the size of the transaction log at a decent size. If the transaction log fills up your disk drive. It can hang up the database. T-log is like archived redo log files in oracle database. Instead of storing multiple files, SQL server stores the t-log as a … Continue reading Trucate Transaction Log in SQL Server 2000/2005

Advertisements

Backup SQL Server 2005 Script

1) Create a text file and name it Backup_All_Databases.sql (or what ever you want). 2) Paste the below script in it: Code: DECLARE @BackupFile varchar(255), @DB varchar(30), @Description varchar(255), @LogFile varchar(50) DECLARE @Name varchar(30), @MediaName varchar(30), @BackupDirectory nvarchar(200) SET @BackupDirectory = 'C:\Backuped_SQL_DB\' --Add a list of all databases you don't want to backup to this. … Continue reading Backup SQL Server 2005 Script