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 |
|
PingTheServer
Starting Member
28 Posts |
 Posted - 2009-01-02 : 12:53:15
|
| Lets say someone makes a mistake,like leaving off the where clause when updating, and we need to restore a single column or table.I have a full backup and a transaction log backup from an hour ago.How would I accomplish this? Restore to a new db first? If so, what then? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-02 : 12:56:07
|
| do you have any audit columns in your table like datemodified? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
PingTheServer
Starting Member
28 Posts |
Posted - 2009-01-02 : 14:13:58
|
quote:
Originally posted by tkizerThen use T-SQL to move the data between the two databases.
Do you know where I could find some examples. Google isnt coming up with much for me right now. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
PingTheServer
Starting Member
28 Posts |
Posted - 2009-01-02 : 15:14:59
|
| that can get me practicing. Thanks Tara. You and your co-moderators really make this a good resource - if you dont hear it enough. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Restore a column