Possible Solution to Keeping Log Size Under Control During INDEXDEFRAG
From: Brad (brad_at_seesigifthere.com)
Date: 08/01/04
- Next message: Brad: "Re: FTP Directly into SQL Server"
- Previous message: Uri Dimant: "Re: inserting XML into msSQL"
- Next in thread: Jacco Schalkwijk: "Re: Possible Solution to Keeping Log Size Under Control During INDEXDEFRAG"
- Reply: Jacco Schalkwijk: "Re: Possible Solution to Keeping Log Size Under Control During INDEXDEFRAG"
- Reply: Andrew J. Kelly: "Re: Possible Solution to Keeping Log Size Under Control During INDEXDEFRAG"
- Reply: msnews.microsoft.com: "Re: Possible Solution to Keeping Log Size Under Control During INDEXDEFRAG"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 1 Aug 2004 09:41:10 -0400
If I just backed up the log to a network drive every 15 minutes or so
during an INDEXDEFRAG wouldn't that keep the file size under control? I
have an extensive defrag that I've only been able to get partially
through because of space and I figure this will let me run it completely
in one shot.
- Next message: Brad: "Re: FTP Directly into SQL Server"
- Previous message: Uri Dimant: "Re: inserting XML into msSQL"
- Next in thread: Jacco Schalkwijk: "Re: Possible Solution to Keeping Log Size Under Control During INDEXDEFRAG"
- Reply: Jacco Schalkwijk: "Re: Possible Solution to Keeping Log Size Under Control During INDEXDEFRAG"
- Reply: Andrew J. Kelly: "Re: Possible Solution to Keeping Log Size Under Control During INDEXDEFRAG"
- Reply: msnews.microsoft.com: "Re: Possible Solution to Keeping Log Size Under Control During INDEXDEFRAG"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|