A. SQL SERVER 2005 Handle error Transaction Log is full : set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go — ============================================= — Author: <Author,,Name> — Create date: <Create Date,,> — Description: <Description,,> — ============================================= ALTER PROCEDURE [dbo].[empty_log] AS BEGIN — SHRINKFILE LOG FILE DBCC SHRINKFILE(<logicalname_log>, 1) BACKUP LOG <dbname> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<logicalname_log>_log, 1) END B. … Continue reading
Note : don’t login using ‘sa’, please login using windows authentification for creating schedule/maintenance plan Creating a SQL Server 2005 Maintenance Plan If you are going to use new Maintenance Plan features, I strongly recommend installing SQL Server 2005 Service Pack 1 first. Among the new features and improvements that are included in SQL Server … Continue reading