Recommended Posts

I have a 900mb SQL database which i have just found has a 48gb LDF File for it. This database has now been put into retirement and only accessed for reference. I am doing a FULL backup on the Database and want to be able to reduce the size of the file.

I have read that i can back up the Transaction log and this will reduce it, but am v limited to disk space and don't want to fill the drive up with the backup before it reduces it.

How big will the backup of the transaction log be with a 48GB LDF File?

How much will it reduce it by?

Can i limit the size of the LDF file growth?

Thanks

Link to comment
https://www.neowin.net/forum/topic/598247-sql-2000-uber-large-ldf-file/
Share on other sites

  • 1 month later...

Ask suggested by Cephas, i set the database to "Simple" recovery model and then (Making sure i had a backup of the MDF, LDF and BAK file) performed a Shrink on the Transaction Log.

This did the job, it took the transaction log down from 55GB to 512kb, but increased the MDF file by 300MB.

As this database has basically been retired i can cope with the "Simple" model and the backup size.

For reference, if you're not running a maintenance plan (backup and shrink) on the database than the LDF file will just continue to grow and grow. I appreciate that you're asking about maintenance plans in the other thread, but if you were wondering why you had a 48GB LDF then that's why.

If this happens in future and you want to keep the backup mode on Full then just do a manual backup of the database (then delete it, if you want) then do a shrink.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Honestly, I think the long-term play here is for Microsoft to ditch the idea of a traditional console entirely and just turn Xbox into a full-on operating system. They (or anyone!) could release hardware like a Mac Mini or a typical console with built-in GPU and RAM, but instead of being locked into a console ecosystem, they run the Xbox OS. It makes total sense because it pushes Game Pass, Windows, and all their other software. The handheld angle is really interesting too. You’d basically have a portable PC. Hook up a keyboard and mouse, and suddenly you can edit videos or get some real work done while on the go. Something like a prebuilt Xbox PC would be more than just a gaming box. It could be a decent little PC that people might actually upgrade with each generation. And since it’s running a PC-based OS, you’d get all the usual perks like mod support, cheaper games across different stores, and no extra charges just to plug in a webcam or other standard accessories. Plus, if they let you install the OS on your own rig, then you’ve got full upgradability too. Best bit also being Microsoft wont even need to build them anyone can and when they do Microsoft just wins. The competition is kind of stuffed. Those maybe relying on SteamOS might be ok but will still have software support issues and no Game Pass. Sony and Nintendo can’t really offer the same kind of flexibility at all not sure how they will live on. They’d struggle to match something that works as a desktop OS, console, handheld, streaming box, and media hub, all with your game library ready to go, never needing to rebuy games. Console exclusives are the only way they can live I think, but if they ever get blocked by antitrust rulings down the line, it’s game over. I'm waiting to see the bloat that's still left on these and if they let you install on a regular old PC. Fingers crossed this could be the lightweight OS we have been asking for.
    • I take my Apple Watch off at night and put it on the charger when I go to bed. Then I wake up the next morning I put it back on.
    • I don’t get what an ai device like a pendant does for me. As a man, I’m not wearing pendant. Then there is battery life. Battery life on my Apple Watch is horribly embarrassing. Having to charge every 36 hours is horribly inconvenient. Fitbits that hold a charge for 5-7 days are much better, so the pendant would need that level of charge. Voice is actually jarring for me. I find it inconvenient when people talk into their phones and I overhear their request. Speaker phones are fine in a closed office but not when others are around. If the device is screen less, it must either respond vocally or respond via the screen on my phone. if this another health device, does the marketplace need another?
  • Recent Achievements

    • Reacting Well
      NeoToad777 earned a badge
      Reacting Well
    • Reacting Well
      eric79XXL earned a badge
      Reacting Well
    • First Post
      brynmot earned a badge
      First Post
    • Reacting Well
      brynmot earned a badge
      Reacting Well
    • Week One Done
      Al_ earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      479
    2. 2
      +FloatingFatMan
      277
    3. 3
      ATLien_0
      243
    4. 4
      snowy owl
      209
    5. 5
      Edouard
      187
  • Tell a friend

    Love Neowin? Tell a friend!