I have a Database on my production server having sql server 2005
and Full-Text search is enabled on this database.
But I restored that database on testing server with TSQL
and didn't include Full-Text files.
and after that i was not able to take full backup of Testing Database
and taking Files and Groups Backup
Now, Someone deleted .mdf and .ldf files from Testing Server and Database is lost
The (+) sign which is against every database vanishes and all options except Properties after RIght-Click on that DB is disabled.
And I'm not able to restore this Backup of File and Groups that Database
and not even on new Database.
Now I have Full Backup of Production Database of last night and Files and filegroups backup of Testing DB of Today evening.
What should i do ?
Please Help !