Hi, one of the customers sent a completed backup of sql 2000 db to us and it turned out that they use .mdf,.ndf,log; how can i remove .ndf file and just use .mdf and .log; if I go with 3 files format, it will mess up the current standard (two files); in additional to that, the backup file has two additional files "sysft_attachmentkeywords and sysft_faqcatalog.
I have already tred:
DBCC SHRINKFILE (LOGICAL FILE NAME EMPTYFILE) and it didn't work.
many thanks,
I have already tred:
DBCC SHRINKFILE (LOGICAL FILE NAME EMPTYFILE) and it didn't work.
many thanks,