Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 9th, 2003, 09:53 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Default Is there any way of disabling logging?

Is there any way of disabling logging while an ALTER TABLE command is executed? We need to increase the size of a Last_User field from char(20) to varchar(50) on all the tables in the database (thanks to the network guys changing the logins to the network). Obviously, if we try a straight ALTER TABLE we blow the log file rather quickly. I don't think we have the option of increasing the log file space to fit, as I assume that would require about a much space as the db itself (currently ~20GB).

All suggestions welcomed,

Cheers,

Chris



There are two secrets to success in this world:
1. Never tell everything you know
__________________
There are two secrets to success in this world:
1. Never tell everything you know
 
Old October 9th, 2003, 11:52 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

I don't think you can totally turn off logging, but you can temporarily set the recovery model to simple via:
Code:
ALTER DATABASE yourdatabase
    SET RECOVERY SIMPLE
which will minimize the amount of log space used.

Make sure you have a full backup before you make your changes, as the only recovery possible using the SIMPLE model is to restore from the last backup.

Also make sure to set it back to whatever model your database is currently using.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
SSIS - Built-In Logging / Custom Logging ivobecker23 SQL Server 2005 0 April 21st, 2006 05:41 AM
Redirecting and Logging off. rupen Classic ASP Basics 3 June 6th, 2005 07:19 AM
Error Logging upbuy6am General .NET 3 October 28th, 2004 03:28 AM
logging users kosla78 Classic ASP Basics 3 December 8th, 2003 01:52 AM
Logging into other sites JonnyRPI Classic ASP Basics 4 June 7th, 2003 04:02 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.