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 |
|
Frozen_123
Starting Member
33 Posts |
 Posted - 2008-04-11 : 17:44:58
|
| Hi All,I have backup of xyz database (xyz.bak). I want to restore auditing table from my xyz.bak file to another server. In directly I mean I want to restore only one table from my backup. Could anyone please help me to perform this activity.Urgent help would be appriciable..Regards,Frozen |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-11 : 17:51:46
|
| You can't do that SQL 2000. Only SQL 6.5 had that features.I would use Import/Export wizard to export table to another server and apply constraints. How big is table? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-11 : 17:52:17
|
| You can't do that directly in 2000. But indirectly you can restore the backup to a different database name and then extract the table from this new database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Frozen_123
Starting Member
33 Posts |
Posted - 2008-04-11 : 18:01:44
|
| Thanks All,Now I'll going to restore that database to another server and after restoring I will going to use BCP or Export/import wizard. Right now I am using Full recovery model for database where xyz table has been deleted but my question is which recovery model should I use to Import the records so that my transaction log file will not fill up.Regards,Frozen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-11 : 18:05:53
|
| 1. Just restore to the same server, but with a different database name. That way you can use T-SQL to move the table rather than import/export.2. It depends on your business requirements. If using FULL recovery model, you need to backup your transaction log on a frequent basis. Typically people do it every 15 minutes or every hour. This helps manage the LDF file size plus gives you the ability to do a point in time restore in case of a problem like a table has been deleted 30 minutes ago and the data from the full backup is too old.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Table restore