+ Post New Thread
Results 1 to 4 of 4
Thin Client and Virtual Machines Thread, Very large Citrix XenAPPRMS_log.ldf in Technical; We're running Xenapp 4.5 and I've noticed that the .ldf for for the database is almost 4Gb, should it be ...
  1. #1
    cookie_monster's Avatar
    Join Date
    May 2007
    Location
    Derbyshire
    Posts
    4,196
    Thank Post
    392
    Thanked 278 Times in 239 Posts
    Rep Power
    74

    Very large Citrix XenAPPRMS_log.ldf

    We're running Xenapp 4.5 and I've noticed that the .ldf for for the database is almost 4Gb, should it be this large? It's running on a full SQL 2005 server.

    Thanks.

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    Which database is that for (since you can name your DBs anything)?

    4GB does seem big for a log file mind... have you tried backing up the database to see if it transfers the data to the main database file?

  3. #3
    cookie_monster's Avatar
    Join Date
    May 2007
    Location
    Derbyshire
    Posts
    4,196
    Thank Post
    392
    Thanked 278 Times in 239 Posts
    Rep Power
    74
    Quote Originally Posted by Ric_ View Post
    Which database is that for (since you can name your DBs anything)?

    4GB does seem big for a log file mind... have you tried backing up the database to see if it transfers the data to the main database file?
    There's 2 DB's on the server one is called XenAPP and one called XenAPPRMS. I only remember it creating the first one originally. I'll run a backup and see if that clears the log. Cheers.

    EDIT

    Just ran a backup from Management Studio and the .ldf is still massive (3.4Gb), the backed up Db was only 160Mb. Would a shrink Db work?
    Last edited by cookie_monster; 13th May 2010 at 11:35 AM.

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    Quote Originally Posted by cookie_monster View Post
    Would a shrink Db work?
    Couldn't do any harm

    The other DB is probably your datastore so this one could be one of several others (summary database maybe?)

SHARE:
+ Post New Thread

Similar Threads

  1. Is edugeek as large as it thinks it is?
    By RingOfFlame in forum General Chat
    Replies: 67
    Last Post: 30th January 2010, 09:23 AM
  2. Plasmas / Large LCD
    By Busybub in forum Hardware
    Replies: 12
    Last Post: 19th May 2008, 09:53 AM
  3. [SIMS] LDF growing very quickly
    By rhyds in forum MIS Systems
    Replies: 6
    Last Post: 27th February 2008, 02:47 PM
  4. [SIMS] sims ldf file nearly 17 gig
    By edie209 in forum MIS Systems
    Replies: 11
    Last Post: 22nd November 2007, 10:30 PM
  5. large sims directory
    By Uraken in forum MIS Systems
    Replies: 3
    Last Post: 30th October 2007, 02:28 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •