I am setting up SQL Server 2014 on a new server. I will be moving our existing ERP database to this new server. Our current ERP database is 4 GB.
With SQL 2014, I am creating a new database to restore the backup to. I am setting the inital size of the database to 6 GB but I am not sure what I should set the initial size of the log file to. I have enabled autogrowth on both the DB and log file. The DB will grow by 1 GB and the log will grow by 256 MB.
I do not know much about SQL Server. Do these settings look okay? What is your recommendation for an initial log file size?