Post reply

Shrinking transaction log on the hosted server

  • January 11, 2008 at 9:01 am

    #120201

    Hi all,

    Is it possible to perform the shrinking of transaction logs on the hosted server? If it is possible, how can I perform this?

    Thank you,

    marsovac

  • January 11, 2008 at 9:24 am

    #767192

    I am not sure. If you can connect to the server via your local instance you should be able to run the DBCC commands. Have you tried to execute the DBCC shrink file command?

    DBCC SHRINKFILE (N'LogFileLogicalName', 0, TRUNCATEONLY)


    My blog: http://jahaines.blogspot.com

  • January 11, 2008 at 9:27 am

    #767195

    Note the above is only needed if you want to truncate the log and reclaim space. If not use

    DBCC SHRINKFILE (N'LogFileLogicalName', 0) instead, to just shrink the log file.


    My blog: http://jahaines.blogspot.com

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply