My database (MS SQL 2k) has been crushed some days ago. I've no any backup, but I need to restore information as much as possible. Trouble is... I've lost last file in filegroup (it's broken), that contents images only. (All images were in three .ndf files, 9Gb each of them).
Please, tell me - is it possible to restore any information?
I haven't had to do this, but in SQL 2000 you may be able to attach the file (you do still have the file, don't you?) directly to the database, or perhaps as a new database from which you can recover your data.
Search SQL Books Online for "attaching databases", "sp_attach_db", or "sp_attach_single_file_db".