You can shrink it & it will release space. If Log File sized increased more & not having space in Drive. Note: Initial Size in MB à Based on your daily load you can decide the Size (100 MB to 500 MB or More). ÀProperties àFiles à (File Type: Log, Initial Size in MB, Autogrowth & Path).
Fortunately, if you have Windows 10, there are several steps. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting auto growth on for existing files in the filegroup.ġst check how much space allocated to log File. With those kinds of space constraints, it's easy to boot up one day and find out that your C drive is completely (or very nearly) full. If Log File is pointing to a drive (E or F or C), which is not having sufficient space to Grow the Log File then you may get Error (While running ETLs or running a SQL Query):Ĭould not allocate space for object in database 'vbdotnet' because
