SQL 2012 Standard database link

I have a client that their software company recently upgraded them to SQL 2012 database.  One user accidentally deleted one database.  The software company reattached the database, but no data shows up.  The data is in a separate folder, and I can see the files.  There is no backup to restore from.  Is it possible to relink the data back to the database?
fletchmanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aneesh RetnakaranDatabase AdministratorCommented:
if some one deleted the database, then the older files will also get deleted. You need to use some software to get the original database files in order to reattach them to the database.
0
 
fletchmanAuthor Commented:
What software do you suggest?
0
 
fletchmanAuthor Commented:
They deleted the database from inside of Studio Management.  Is this the same as deleting files from the File Explorer?  The database was still there.  The software support was able to reattach it, but it does not show any data.  The data is still where it was.  Is there a way to "relink" the data to the database?  I'm sorry if I wasn't clear on the initial post.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
When you delete it from management studio, sql will physically delete the original files; the one you saw could be a different copy of your database files, that's why it is empty, check the date when the file was created / last updated ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.