how can i change the initial size of the data and log file size ?
in my database properties it shows that my data file size is 81 mb and log file size is 985 mb! but my database only contains some tables and stored procedures with few rows of data in each table
and i checked that the actual mdf and ldf files are really that big... i tried to change it but it didn't work...
can someone please teach me how to change it thanks!
Backup the DB with Truncate log. check books online for more info.
|||http://www.codeproject.com/useritems/truncate_log_SQL_server.asp
No comments:
Post a Comment