SQL Server mdf files not changing -
here sql server question.
while data getting populated or deleted data base (ex. northwinddb), corresponding mdf file not changing @ all. test restarted sql server services , see change in time stamp , size of mdf file.
is there way can force data base changes reflect in corresponding mdf , ldf files without restarting sql service.
yes, can use: dbcc shrinkfile (transact-sql)
check here.
personally use this:
use mydb; go -- truncate log changing database recovery model simple. alter database mydb; set recovery simple; go -- shrink truncated log file 1 mb. dbcc shrinkfile (mydb_log_name, 1); go -- reset database recovery model. alter database mydb; set recovery full; go
Comments
Post a Comment