:::: MENU ::::

Manage Number of SQL Server 2005 Logs archive Files

  • Oct 06 / 2008
  • 0
dbDigger, SSMS tips and tricks, Transaction log files

Manage Number of SQL Server 2005 Logs archive Files

SQL Server logs files contain valuable information. By default 6 files are archived and any new file removes the oldest one to make its place. In many situations a DBA may require to have more log files archived for a later reference. It is relevant to mention here that a new log file is created every time SQL Srever is restarted.
So how to change the default number i.e. of SQL Server log files

Default Log Files for SQL Server Databases

Go to SSMS
Go to ‘Management folder’
Right click on ‘SQL Server Logs’ folder there
Now you have the interface to manage the number of SQL Server logs files

Consult us to explore the Databases. Contact us