Jump to content

Recommended Posts

Posted

I've got a SQL 2005 server (for Sage mainly); I'm pretty sure I've set up the backup job correctly, followed by a shrink database task, but the ldfs are still 400MB+

 

This is the SQL generated by the shrink task - any ideas why the logs aren't shrinking each time?:confused:

 

USE [sage200_DemoData]
GO
DBCC SHRINKDATABASE(N'Sage200_DemoData', 10, TRUNCATEONLY)
GO
USE [s200_CPSLive_TC]
GO
DBCC SHRINKDATABASE(N'S200_CPSLive_TC', 10, TRUNCATEONLY)
GO
USE [s200_CPS_GoLiveFinal]
GO
DBCC SHRINKDATABASE(N'S200_CPS_GoLiveFinal', 10, TRUNCATEONLY)
GO
USE [s200_CPS_0405]
GO
DBCC SHRINKDATABASE(N's200_CPS_0405', 10, TRUNCATEONLY)
GO
USE [s200_CPS_0506]
GO
DBCC SHRINKDATABASE(N's200_CPS_0506', 10, TRUNCATEONLY)
GO
USE [s200_CPS_0607]
GO
DBCC SHRINKDATABASE(N's200_CPS_0607', 10, TRUNCATEONLY)
GO
USE [s200_CPS_0708]
GO
DBCC SHRINKDATABASE(N's200_CPS_0708', 10, TRUNCATEONLY)
GO
USE [s200_CPS_0908]
GO
DBCC SHRINKDATABASE(N's200_CPS_0908', 10, TRUNCATEONLY)
GO
USE [Cartmel0910]
GO
DBCC SHRINKDATABASE(N'Cartmel0910', 10, TRUNCATEONLY)
GO
USE [Cartmel1011]
GO
DBCC SHRINKDATABASE(N'Cartmel1011', 10, TRUNCATEONLY)
GO
USE [Terms]
GO
DBCC SHRINKDATABASE(N'Terms', 10, TRUNCATEONLY)

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...