June 3, 2008 at 2:56 pm
I delete the file name file.NDF which is on the filegroup because I don't need that. I re started the sql server service and then database will become isShutdown mode so I cannot recover the database.
Now the situation is that I have detached the database and trying to attached without the file I deleted, giving me error.
Is there a way to attached the database with out one particular filegroup.
June 3, 2008 at 3:04 pm
Try using filegroup restore in case you have filegroup backup available with you.
Manu
June 3, 2008 at 3:06 pm
File is deleted and have no backups.
June 3, 2008 at 3:26 pm
If file got deleted properly(without any error message) then your database should come online with no issues. Did you deleted it when database was online(sql service was running) or when sql service was stopped?
Manu
June 3, 2008 at 6:02 pm
No. I deleted the file after stopping sql server service. I physically delete the file from the folder.
June 3, 2008 at 6:14 pm
The .ndf file is a secondary database file - which is defined in SQL Server for that database. I think your only option at this point is to restore the database from backups. If you don't have backups available, then you might be able to start SQL Server in minimal mode and alter that database to remove the secondary file (I am not sure about this, never tried it - so I have no idea whether or not it will work).
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 4, 2008 at 9:12 am
I don't have backup becuase of the development server and also the files are huge and cannot take backups.
After deleting the file, I detached the database and now cannot attached it. I created a new database and started loading the data from the scratch.
Thanks for your help.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply