sql database file recovery - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

sql database file recovery

Author

Topic

sumana
Starting Member

2 Posts

Posted - 2011-09-17 : 02:38:32

Hi
I deleted database file from management studio by mistake. Is there any way to get it back

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-17 : 02:43:00

nope until you've backup store somewhere.
You may use some third party disk recovery tools to recover the deleted mdf,ldf etc files and try attaching them again though

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

markwillium
Starting Member

11 Posts

Posted - 2011-09-19 : 03:05:35

Without backup chances to restore database file is very less. Anyways you can try to restore from recycle bin if available or You can try Stellar Window data recovery software to recover deleted database files.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources