Re: Does DBCC SHRINKFILE on a data file cause the log to grow?
From: Uri Dimant (urid_at_iscar.co.il)
Date: 02/18/04
- Next message: Geoff N.Hiten: "Re: Backups Best Practices"
- Previous message: Malcolm Ferguson: "Does DBCC SHRINKFILE on a data file cause the log to grow?"
- In reply to: Malcolm Ferguson: "Does DBCC SHRINKFILE on a data file cause the log to grow?"
- Next in thread: Christian Smith: "Re: Does DBCC SHRINKFILE on a data file cause the log to grow?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Feb 2004 17:08:19 +0200
Malcolm
Make a long story shortly
1)Perfom BACKUP LOG file ( it removes all inactive transaction )
2)Pefrom DBCC SHRINKFILE to reduce physical size of the log file.
"Malcolm Ferguson" <Malcolm_Ferguson@NO_SPAM_PLEASEyahoo.com> wrote in
message news:ekOInAj9DHA.2472@TK2MSFTNGP10.phx.gbl...
> We have 60GB free of a 140GB data file in one of our databases in SQL
> Server 2000 SP2. I've truncated the free space at the end, but it won't
> shrink any further now. I tried running DBCC SHRINKFILE, but had to
> cancel it and run a log backup when the transaction log grew to 40GB and
> started threatening the free disk space. Is this expected behaviour.
> If it is, can anybody recommend a way to shrink the data file without
> growing the log - e.g. do I have to temporarily change the database
> model to simple, or something like that?
>
> Cheers,
> Malc
>
- Next message: Geoff N.Hiten: "Re: Backups Best Practices"
- Previous message: Malcolm Ferguson: "Does DBCC SHRINKFILE on a data file cause the log to grow?"
- In reply to: Malcolm Ferguson: "Does DBCC SHRINKFILE on a data file cause the log to grow?"
- Next in thread: Christian Smith: "Re: Does DBCC SHRINKFILE on a data file cause the log to grow?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
