Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

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?
0
fletchman
Asked:
fletchman
  • 3
  • 2
1 Solution
 
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now