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 ShawSQL Server MVP |
|
|
|
|
|
|
Recover sql tables from mdf file with filstream