Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mac73
Starting Member
3 Posts |
 Posted - 2010-01-14 : 12:15:11
|
Hi,
I have accidently deleted the folder that has filestream datatype in the database. As a result the sql server database is not loaded in the manage studio.
I tried on another server with mdf file and ldf files but it gives the error that folder that has filestream data doesnot exists. Even if i create the folder it gives me error.
Any way to resolve this? Can i edit mdf file to remove filestream dependency?
I dont need data. I just need tables schemas and er diagrams.
Is there any free tool available that will help me to get the schema?
Any help is appreciated.
Regards
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mac73
Starting Member
3 Posts |
Posted - 2010-01-14 : 12:46:47
|
Hi,
I dont have back up file. I have only mdf and ldf file. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-01-14 : 13:33:43
|
Is the database still attached to a SQL instance? (probably the original one)
If so, what's the database state? (query sys.databases)
--
Gail Shaw
SQL Server MVP |
|
|
|
|
|
|
Recover sql tables from mdf file with filstream