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 |
|
quietrioter
Starting Member
1 Post |
 Posted - 2005-04-22 : 11:37:16
|
| We have a 500 GB database for which we backup files to tape every weekend(file copy to tape and NOT DB backup). The idea being that , in case of an accidental drop table or truncate we can detach the DB and attach the last back up file from above instead of the current version of the file. Data in the DB is distributed across 6 file groups and 18 files.This week, while making some data moves across tables we lost data from a couple of tables that belong to the same file group.So we detached the DB, renamed the existing files in the DB that belonged to the above file group, copied the backups of these files from last weekend's backup from tape into the appropriate locations and then attached the DB with these files.The DB re-attached fine but the tables that lost the data are not seeing the data(select returns nothing). Since the backup, we had dropped and re-created these tables(with the same names , of course) so I'm not sure if there's a internal referencing issue. I hope I'm clear in explaining this, and would appreciate a fast response from anyone who's familiar with the above.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-22 : 15:50:58
|
| Your file copy to tape...are you detaching the database, then copying the MDF and LDF files to tape?Tara |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-04-22 : 16:33:54
|
You have a real problem if you don't have a real database backup for a database this size.quote:
...file copy to tape and NOT DB backup...
Did you ever try this before now, or did you just assume this would work? I really doubt that it will.quote:
...The idea being that , in case of an accidental drop table or truncate we can detach the DB and attach the last back up file from above instead of the current version of the file...
You should talk to Microsoft about this. They may be able to walk you through something to get you back in action.CODO ERGO SUM |
|
|
|
pentiumsingh
Starting Member
9 Posts |
Posted - 2005-04-25 : 01:18:10
|
| Hi I am not able to get one thing clear you have droppped and recreated the data 1. before backup or 2. after backup and before restore or3. after restoreIf second is the case( i hope that is wht is specified ) Wht all restoration you have done only the restoration of those file which had the related tables and data you needed or all of them If you wld have done only the required datafiles and not all the datafile then the enrty in the sys tables of your database is having the entry wht all deletion and recreation of table you have done before restore so even if you restored your tables (manual restore of files), that doesnt change the enteries in the systable , which doesnt affects your viewI hope i am clear in some points If you neeed any more assistance please reply or feel free to mail me pentiumsingh |
|
|
|
|
|
|
|
|
Urgent--lost data recovery