Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2008-04-23 : 06:01:05
|
| HiI created database and kept its recovery model as FULL and insert data in DB i fired DBCC SQLPERF (LOGSPACE) and see Log Space Used (%) is @ 99 then I changed DB recovery model to simple and see Log Space Used (%) is @ 19 please any body guide me what happened when i changed recovery model??T.I.A |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-23 : 07:44:35
|
| Probably the chnage cussed a checkpoint and when using yte simple recovery model the log is truncated on checkpoint i.e. all entries that can be released are released.Have a look at http://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-23 : 23:14:03
|
| You have to backup log to truncate committed transactions if db is in full recovery model. |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-27 : 14:22:44
|
| Basically once your DB is in FULL recovery mode then it will use the checkpoint for certain limit. If you want to change the DB from FULL to SIMPLE recovery mode. Take Full and Tlog backup and then try to make DB in SIMPLE recovery.In Simple recovery it will set to minimum latency for log.ManojMCP, MCTS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 23:49:23
|
| >> once your DB is in FULL recovery mode then it will use the checkpoint for certain limit.What kind of limit?>> In Simple recovery it will set to minimum latency for log.Don't get it, can you explain? |
|
|
|
|
|
|
Log space issue????