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 |
|
Rushabh
Starting Member
11 Posts |
 Posted - 2008-10-09 : 10:32:47
|
| Hi all,I want to restore one table in SQL Server 2005 standard edition.The backup is on SAN storage.Can anyone help me write a script for this.Regards,RushabhDBA |
|
|
lepeniotis
Yak Posting Veteran
75 Posts |
Posted - 2008-10-09 : 10:52:26
|
| If the table is in a different filegroup you can restore the filegroup. But What I would do is to restore the backup file as a different database (from the restore that you have the table like you want)and take the table and then insert it on the old database. The easiest way is to rename the old table or to delete it (I wouldn't do that).RegardsMSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
 |
|
|
Rushabh
Starting Member
11 Posts |
Posted - 2008-10-09 : 10:56:13
|
| hey thanks for the suggestion..i will try to do that.. hope it works..if anyone has a query for that, it would be great..Regards,RushabhDBA |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-10-09 : 10:57:33
|
| If you are using Quest Litespeed for backups & restores,you can restore a table from a backup file.. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-09 : 11:04:21
|
quote:
Originally posted by swekik
If you are using Quest Litespeed for backups & restores,you can restore a table from a backup file..
Really !! I didn't know that. Is it true? |
|
|
|
|
|
|
restore one table