Re: recover mode and the transaction log file question
From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 04/13/04
- Next message: ajmiester: "Updating data based on timestamp"
- Previous message: Rich: "using xp_cmdshell to run a droplet"
- In reply to: Dan Guzman: "Re: recover mode and the transaction log file question"
- Next in thread: Kent Eilers: "Re: recover mode and the transaction log file question"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 12 Apr 2004 21:01:20 -0500
Thanks Dan, I should have mentioned that.
-- Andrew J. Kelly SQL MVP "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message news:eBl$JADIEHA.3988@tk2msftngp13.phx.gbl... > To add to Andrew's response, you need to perform a full backup after > changing the recovery model to FULL. > > -- > Hope this helps. > > Dan Guzman > SQL Server MVP > > "Kent Eilers" <kent@kaeServices.com> wrote in message > news:shlec.33467$YC5.30597@twister.rdc-kc.rr.com... > > It's been about seven years since i've worked with SQL Server...(ouch) and > > I"ve been playing around with it on my home PC. > > > > My goal is to get the transaction log filled. I've reviewed the new > > 'recovery mode' options and have set the recovery mode for my test > database > > to 'full' with the following command: > > > > <alter database leads set recovery full> > > > > I have setup the log file to not grow at all. It is set at 3 MB. > > > > I then have added records into a table with an insert statement. > > > > I check the log file status using the "DBCC SQLPERF(logspace)" command > > after every insert. > > > > I can get the 'log file' full message triggered if I insert a large enough > > batch. If I insert smaller amounts of data the log space fluxuates -up > and > > down! It maxes out in the 60 - 70 % full then is at 20% after the next > > insert! > > > > It this the correct behavior given the recovery mode/T-log parameters I've > > mentioned above? If so what am I missing here? It seems like the > database > > is doing automatic truncate log commands behind my back - but nothing of > the > > sort is being logged in the SQL Server log files. > > > > Any feedback much appreciated. > > > > -- > > kent eilers > > kent@kaeServices.com > > > > > >
- Next message: ajmiester: "Updating data based on timestamp"
- Previous message: Rich: "using xp_cmdshell to run a droplet"
- In reply to: Dan Guzman: "Re: recover mode and the transaction log file question"
- Next in thread: Kent Eilers: "Re: recover mode and the transaction log file question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
