Cannot shrink virutal log file
I have a virtual db restore that I am testing with updates and inserts of a million records. Each time I run a transaction, the virtual log grows 1 GB. I have tried backing up the virtual log (successful) but when I try to shrink the file using DBCC shrinkfile (db_log,0), I am unable to shrink the red gate virtual log (the log size stays the same). How can I shrink the virtual log file?
0 · Share on Twitter