I have a log file that is 148GB (yes GB) but available space is 18GB. I am backing up to \\server\share temporarily but want to free up the space. How do I flush it? I ran maintenance to shrink but not nuch success. It was not setup right initially, as the max size is 2,048,512 (MB). I'm guessing the initial dba was thinking it was KB. Anyway, I need to flush (or whatever it is called now) to reduce the size.
We had BackupExec but they got rid of that for Symantec Backup Exec System Restore which backs up the whole server as an image so it does not backup and flush the logs.
Any suggestions?
Thanks in advance.Hi,
see this kb for more information: http://support.microsoft.com/default.aspx/kb/873235
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment