Our server storage capacity has been increased and but on a different drive than Sql7 is using. I have moved the log and primary datafiles to their new location and need to merge two data files together. The size of the datafiles I hope to remove is much larger than the log file can grow.
What should I do ? Is logging used ? Can logging be turned off ? Would this even help ?
Thanks
How I moved the data files.
use master
sp_detach_db 'ZD1'
sp_attach_db 'ZD1'
,'j:\sqldata\zd1data1.mdf'
,'g:\zd1data2\zd1data2.ndf'
,'e:\sqldata\zd1log1.ldf'
How I plan to remove data file zd1data2.
use ZD1
dbcc shrinkfile (zd1data2, emptyfile)
Alter database ZD1 remove file zd1data2