Re: sqlmaint Question
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 03/01/05
- Next message: Simon Lidberg [MSFT]: "Re: Strange problems accessing SQL server with windows 2000 windows authentication. Please help :)"
- Previous message: Sam: "database restore"
- In reply to: kevinsharp69: "Re: sqlmaint Question"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Mar 2005 16:52:13 -0500
Are there any long running open transactions that are preventing the
truncation? What does DBCC OPENTRAN say? Did you do a FULL backup before
you started the log backups?
-- Andrew J. Kelly SQL MVP "kevinsharp69" <kevinsharp69@discussions.microsoft.com> wrote in message news:9B3FB572-320F-43C4-9E8F-74726B21BDAC@microsoft.com... > Actually i'm not looking for it to shrink the file but actually clear the > transactions that have been backed up. Previous to the backup the log was > fixed at 60MB and 8.9MB was used, after the backup there was still 8.9MB > used. > > "pdxJaxon" wrote: > >> it's not going to shrink the file and in fact, you probably dont want it >> to >> as Re-Growing the file later is an expensive operation. >> >> If you REALLY Need to shrink the file you can use: >> >> DBCC ShrinkFile >> or >> DBCC ShrinkDatabase >> >> >> Greg Jackson >> PDX, Oregon >> >> >>
- Next message: Simon Lidberg [MSFT]: "Re: Strange problems accessing SQL server with windows 2000 windows authentication. Please help :)"
- Previous message: Sam: "database restore"
- In reply to: kevinsharp69: "Re: sqlmaint Question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
