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 |
|
wango tango
Starting Member
3 Posts |
 Posted - 2007-04-24 : 11:15:12
|
| Hello,Is there a way we can replicate a db to another server without putting what appears to be exclusive locks on the db? When the DTS package starts, it basically shuts down our application from using it until it is done with its replication, and is causing major grief.TIA |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-04-24 : 11:34:19
|
| Why not use the poor man's replication "backup + restore"? |
 |
|
|
wango tango
Starting Member
3 Posts |
Posted - 2007-04-24 : 12:38:36
|
| we have to do this 2x a day, and we only need a subset of the data. the db is quite large too. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-24 : 12:53:01
|
| Can try transactional replication. |
|
|
|
wango tango
Starting Member
3 Posts |
Posted - 2007-04-24 : 17:38:03
|
| is this the same as publishing a db etc? we tried that too and it still caused locking issues. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-24 : 20:53:33
|
| You tried snapshot replication? Yes if so since it'll recreate tables with default settings. |
|
|
|
|
|
|
DTS locking db