Sql 2000 full backup

[19972003]

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,

 

[hmckillop]

The SQL backup contains all the files they specified in backing it up

The two "Sysft_" files are for full text indexing catalogs

The .mdf and .ndf files are two data files used to store data and the .log (or normally .ldf) is the log file.

The way I see it, you cant restore to the "standard" two files, you must restore the backup as is or you will lose data

Believe it or not, two files are not necessarily the best thing to do, particularly in a high concurrency multi disc system.

Have a look at

http://sqlserverpedia.com/wiki/Configuring_Database_Files_for_Optimal_Perfomance

"I'm living so far beyond my income that we may almost be said to be living apart

 

[19972003]

I guess I will need to use 3 files so that I don't loose any data, will it matter if I run sql 2005? because the file I got from the vendor is sql 2000.

 

[hmckillop]

it shouldnt matter if you are restoring in sql2005 from a sql2000 backup.

"I'm living so far beyond my income that we may almost be said to be living apart