Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sql 2000 full backup

Status
Not open for further replies.

19972003

MIS
Feb 16, 2007
205
US
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,
 
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



"I'm living so far beyond my income that we may almost be said to be living apart
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top