March 11, 2009 at 10:43 am
Hi
I met an problem.My client has accidentally deleted some tables from the database(in sql server 2005) some days ago.Now he wants to recover the data and tables again.Is there any way to get it in sql server 2005 without using any external tools since he doesn't want to install any external tool in its database server other than sql server 2005.
Can somebody also tell me that if this happen in sql server 2000 then how can we recover the data and tables without using any external tools?
Thanks in Advance!
Nothing Is Impossible
March 11, 2009 at 10:56 am
If they have a backup of the database prior to the data being deleted then they can restore (to another database) and copy the appropriate information across. If they have an uninterrupted chain of log backups from the full backup to the time of deletion then they can use a point-in-time restore to prevent any data loss, otherwise they would lose modifications between the full backup and the time of deletion.
They may also be able to recover the data if they are using database snapshots or if they are replicating.
March 11, 2009 at 10:57 am
With only using the Native SQL server tools, you will need to restore a backup of the original database(db1) (+ any required differential or transaction log backups) from a time when those tables existed to another database (copy) and then script out the tables and copy the data from the copy database to db1. There is no way in SQL Server 2000/2005 to restore only portions of a database i.e. a table or a procedure using the native tools, unless it was partitioned to begin with in which case you can restore a partition, but that does not seem to be your case.
-Luke.
March 11, 2009 at 10:57 am
To answer your question this question needs to be asked I guess..
Do you have back up?
-Roy
March 11, 2009 at 12:03 pm
Thanks friend
Can u please tell me how can i use the point to restore since i have the database taken day before tables are deleted.
Nothing Is Impossible
March 11, 2009 at 12:05 pm
Thanks friend
Can u tell me how can i read the transaction logs in sql server?
Vivek
Nothing Is Impossible
March 11, 2009 at 12:06 pm
Thanks Friend
I have the backup of the database,day before the tables are deleted
Nothing Is Impossible
March 11, 2009 at 12:08 pm
Restore the DB back up in another system and then get the table that you need.
-Roy
March 11, 2009 at 12:50 pm
If you have a LiteSpeed backup, you can restore the table directly.
March 11, 2009 at 1:33 pm
You don't need any special tools if you have good backup procedures in place. If you have a Full backup, and if your database is in FULL RECOVERY mode, and if you have transaction logs since the full backup, then you can recover to a specific point in time. Otherwise you can only go to the latest Full backup.
Maybe it would be easier for you to list more information about the database recovery model, what type of backup you have, then we can come up with the best solution.
March 11, 2009 at 3:41 pm
Nothing Is Impossible
Some things are.
* Noel
March 11, 2009 at 6:48 pm
noeld (3/11/2009)
Nothing Is Impossible
Some things are.
Such as recovering databases when there are no backups.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply