asked on
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?
Microsoft SQL ServerMicrosoft Legacy OS
Last Comment
Aneesh
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.
ASKER
What software do you suggest?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
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 ?