RE: Unable to Shrink Files

From: Emma (eeemore_at_sjindustries.com)
Date: 03/30/04

  • Next message: Hilary Cotter: "Re: Date field and replication" 
    Date: Tue, 30 Mar 2004 10:28:45 -0800

    This is where I get confused. I am backing up the
    database first with SQL backup utility and then with
    Veritas Backup Exec. I tried shrinking after performing a
    full backup. I thought that the backup will automatically
    truncate the file.

    >-----Original Message-----
    >Emma,
    >Shrinking a log is dependent on first truncating the
    log - are you backing it up? Once you have then DBCC
    SHRINKFILE should work. If you want a simpler solution
    and only require database backups, you might consider
    using Simple Recovery Mode. This article may help explain
    hte procedure: http://www.support.microsoft.com/?
    id=272318.
    >Regards,
    >Paul Ibison
    >.
    >

  • Next message: Hilary Cotter: "Re: Date field and replication"

    Relevant Pages

    • Re: Fragmentation Issues
      ... My backup schedule is a full each night in the early morning. ... if I do a full backup and then trucate the tran log I have all I need to ... Do you recommend never shrinking the DB -or- when would you recommend ...
      (microsoft.public.sqlserver.server)
    • Re: Fragmentation Issues
      ... Tibor Karaszi, SQL Server MVP ... > backup is run each day at 1:00p. ... >>> dbcc checkdb ... > Do you recommend never shrinking the DB -or- when would you recommend ...
      (microsoft.public.sqlserver.server)
    • Re: Tran Log Growth high tried truncating and shrinking
      ... And only after trans ... > have been committed and a full backup taken. ... It is not the shrinking that is harmful it is the growth that will ... temporarily halt any new transactions until the growth is complete. ...
      (microsoft.public.sqlserver.server)
    • Re: Transaction log too big
      ... For SQL Server backups, the file size is not what determines the size of the backup. ... and I also agree that shrinking has a place for "unregular" operations. ... > that's empty though - the physical file will still have the same size on ...
      (microsoft.public.sqlserver.server)
    • 2 Qs: DB Shrink and Agent step
      ... Q1: shrinking transaction log ... backup log file with successfully, ... SQL Server Agent only runs step 1 ...
      (microsoft.public.sqlserver.server)