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 |
|
jhoover
Starting Member
2 Posts |
 Posted - 2008-01-08 : 11:05:56
|
| I need some advice for an issue with a production transaction log min size having been set to 50 GB by some rouge developer while I was on vacation. Now, as the only resident DBA, I'm responsible for going in and reducing it down so we can free up limited disk space. It’s in SQL 2000 and participates in replication.Because the log file cannot be set below its current minimum size, I’m a little stumped. Can I somehow force the minimum size by updating the table database.dbo.sysfiles?Otherwise, what do you-all think of this plan?1.) Back up the database.2.) Verify no open transactions with DBCC opentran(‘database’) and proceed accordingly.3.) Change it to single user mode.4.) Set it to Simply Recovery mode.5.) Issue a checkpoint to clear the log.6.) Script out push replication.7.) Delete replication.8.) Detach it.9.) Delete the Transaction Log.10.) Attach it and let SQL Server recreate a transaction log to the SLQ Server default size.11.) Run the Replication Script.12.) Start the Snapshot Agent.13.) Restart the Transaction Log Reader Agent.14.) Celebrate a Victory!Thanks in advance for your help!Jeffrey.Hoover@gmail.comMinneapolis, MN |
|
|
jhoover
Starting Member
2 Posts |
Posted - 2008-01-08 : 17:25:46
|
| I've tried this in a test DB. Works fine. It just is a little uncomfortable to do!Jeffrey.Hoover@gmail.comData ArchitectMinneapolis, MN |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-08 : 17:32:08
|
| Just make sure you dont re-initialize the snapshot if you are sure the subscriber db hasnt been touched.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 23:29:07
|
| Tried just shrink it in em? |
|
|
|
|
|
|
Shrink TL below set MIN size