how to prepare a database backup with a single data file

To any kind personwho can help...

I have been backing up my discountasp.net database using the sql tool suite for quite awhile. I wanted to restore the bak file to another dasp website, and got the error message stating it is not possible to restore a bak file with more than 2 data files.

Within each bak file, I thought there was only one database file, and don't know how the other one got there unless it was automatically placed there. I queried the help desk, and got the answers below which hopefully could help you to answer my questions:

1. How can I prepare a database backup with a single data file, ie: could the 2 be merged? And if so, I don't know the name of the other data file to merge, but suspect it is part of the answer below...

2. Have I been backing up the database incorrectly, since I can't seem to even restore it, giving me a false sense of security?



Dear Customer,

You'll want to post in the Database topic in the DiscountASP.NET Community Forumand ask how to prepare a database backup with a single data file.




Dear Customer,

we checked the backup database that you are trying to restore and we see that
your bak file has more then 2 data files. Unfortunately our system does not
support more then 1 data file (ndf file)

--SQL2005_445412_imarounds_data E:\SQLData\SQL2005_445412_imarounds_data.mdf
D
--FileGroup_v01-30-08 E:\SQLData\FileGroup_v01-30-08.ndf D
--SQL2005_445412_imarounds_log F:\SQLLog\SQL2005_445412_imarounds_log.LDF
L


Your help will be greatly appreciated.

Thank you,
Scott

 

Bruce,


Thanks for your question. I looked in my database under "storage" then "full text catalogs" and nothing comes up. So I think the answer to your question is no.





Scott