April 23, 2008 at 1:24 pm
I have a small doubt if we are not able to login in to sql server(all the necessary permissions are there ) how can we troubleshoot this type of problems.(the general steps to follow)
In a particular database only one table has been deleted.In sql 2005 can it be possible to restore that table only.If so the general procedure for that is..
I would be thankful for the valuable suggestions.
April 23, 2008 at 1:34 pm
Indirectly, yes it is possible to restore just one table.
Directly, no you can not restore just one table from a database.
Indirectly, you restore the database as a different name or to a different server and then import the table in question after truncating the data in the main database. Then drop the restored database.
Dave Novak
April 23, 2008 at 1:34 pm
SQL's native backups do not allow you to just restore a single table. You'll have to restore the entire database either as a new DB on the same server of on another server, then copy the missing table across.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 23, 2008 at 1:36 pm
1)check whether the login is windows or sql .
if the login is windows check whether login permission is granted.
2)For copying a table that has been deleted, first restore the database from recent full back up with different name and then copy the table to the database from where u deleted
Binu M A
SQLDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply