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 |
|
Credo
Starting Member
5 Posts |
 Posted - 2009-07-15 : 09:33:44
|
| Hello all,I'm new to this forum - so please bare with me... I'm working on a new replication of a 100+Gb database over the network. Speed isn't really an issue as the snapshots are taken and pulled on off-peak hours. However I'm having a problem with the initial snapshot.I've set everything up nicely with the SQL default "Pubs" database. The replication there worked fine. However when I've attempted to set up on the large DB, It's error's out about 20 minutes into the initial replication. The subscribing SQL server is located on my machine, which is the same place the snapshot is being placed. it copies over about 2gb worth of data then dies. It's not a free-space issue as I've got over 300+gb available on my machine.The error message is as follows:"The process could not bulk copy '[dbo].[syncobj_0x44568.....]'"Any help would be greatly appreciated. Please feel free to ask any other questions you may need.Thank you very much in advance!! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-15 : 09:54:52
|
| I am guessing this is transactional or merge.When there are no changes taking place (or minimal updates/deletes/inserts), take a backup of the database, then create your snapshot with the option that the other server already has current data, do not try to apply the snapshot yet though. Then restore the backup to the destination. Once completed, apply the snapshot and any data changes will come over.The other thing this might be is your version of SQL 2000.I do remember that with one of the service packs there was an issue whereby some of the snapshot objects created added exxtra fields to the procedures for adding data to the tables.To check what version you are running:Select @@versionthen check against:http://www.sql-server-performance.com/tips/service_packs_p1.aspx |
 |
|
|
Credo
Starting Member
5 Posts |
Posted - 2009-07-15 : 10:02:11
|
| Thanks for the reply!I am running the latest version of 2000 (SP4) 8.00.2039 so I'll try the other way you mentioned with restoring a backup of the database to my local machine, and try from there.thanks for your help. I'll see if this works, and post any results.Cheers!C. |
|
|
|
Credo
Starting Member
5 Posts |
Posted - 2009-07-16 : 12:09:17
|
Hey Rick.I did what you said by applying a backup copy of the database to my subscribing SQL server, then applying the snapshot. When I set up the Push, It's only letting me select "Yes, initialize schema and data" where the "No the subscriber already has schema and data" is not selectable, when this IS the option I would like?Did I miss some steps in order to have this option available? I really need some direction here - I've been working on this for some time now, and can't get this to run... |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
|
|
|
|
|
Replication issues.