You should exercise caution when adding a log file, as doing so affects the entire
SQL Server.
-
With the System Administration window open, click DBA > Add Datafiles.
-
Click the Log tab.
-
In the New file information section, type the datafile name, the datafile location, and the initial size (in MB).
-
Click Apply to add the filegroup.