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 |
|
hsac1301
Starting Member
1 Post |
 Posted - 2011-08-15 : 17:53:22
|
| Hi All,My user has requested to automate the process to refresh the sql 2008 test system from live excluding one table(t1) and (every table has id column) where livetableid ='123' and testtableid='R123' only. Can you please advise the best method to perform this operation.Many ThanksHsac |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-15 : 23:49:06
|
| Restore a backup from live to test.Then delete/drop what needs to be excluded. |
 |
|
|
|
|
|
SQL Server 2008 R2 Database refresh