Monday, March 12, 2012

Log File Flush Training for Newby

Sorry to ask such a basic question but I have inherited this DBA position and I have no SQL training...

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