Microsoft SQL – Force logfile rotation

By default SQL maintains 7 ErrorLogfiles and rotates them, trowing away the oldest log and creates a new one. If logfiles grow big in size and ‘eat up’ all your HDD space you can force the logfile rotation. The default logfile names are: ErrorLog ErrorLog.1 ErrorLog.2 ErrorLog.3 ErrorLog.4 ErrorLog.5 ErrorLog.6 The normal logfile cycle goes […]

Read More »