Home Forums SQL Server 2005 Administering Changing the initial size of db file RE: Changing the initial size of db file
nlindebringhs
SSC Rookie
Points: 42
More actions
March 30, 2011 at 10:58 pm
#1305781
Make sure the log has been backed up first or set the recovery model to simple.
This will allow the log file to be shrunk to a size smaller than the original file size specified.