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 |
|
kselves
Starting Member
4 Posts |
 Posted - 2008-02-14 : 10:04:16
|
| I have two servers (server 2003) both running SQL Server Enterprise Edition Version 8. One SQL server is Primary, the other is Secondary. The system was doing a daily export from primary and import to secondary, but that quit working a while back. I'm trying to copy the databases from the Primary to the Secondary and than set up replication. I'm already stuck at copying the databases over using the copy database wizard. The servers are not on a domain, and the SQL server service is running as user ./sql. When using the copy database wizard i must use windows authication for it to select the Primary as the sourse, as inputing the SQL Server authication user (sql) and password says it cannot connect. When i select one of the databases to copy and run the wizard it gives me an error code -2147467259, in which google did not help me. It runs through the process of creating a temporary share, puts it in single user mode, detaches the DB, but fails to copy the file. I believe it is some sort of permissions issue on the drive, and gave user sql full access, and after that didnt work i gave "everyone" full access temporary to see if that worked but didnt. Do these servers need to be on a domain for this to work? I also read MSoft knowledgebase http://support.microsoft.com/kb/274463 Id rather not have set these up for a domain. Thanks! |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-14 : 11:46:24
|
| This does not answer your question directlym but have you considered doing a BACKUP/RESTORE?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
kselves
Starting Member
4 Posts |
Posted - 2008-02-14 : 12:02:17
|
| I tried that too, but unsucessful. Primary has orginal backup path file autoarchive (timestamp) that i dont want to remove, and if i try adding a path as a second choice, the first choice gives a device error when i run it, like it was going to tape, but its file, and it does create the TRN files. That is on the primary, in which i want to leave orginal. On the Secondary i had backed up the Databases before i deleted them (missing a couple months info), but it only allows it to be in a certain location (F: - created in G:) moved backup file from G to F and specified file drive location, but it doesnt find it. I could restore the secondary DB's from the auto backup, but i would be missing 3 months info, in which i dont think the replication would put that info back in. Im afraid it would (by murphys law) delete info in primary when it does it syncronation, so would like to get the primary DB copied to the secondary than get replication working. Thanks for the thought though. |
|
|
|
kselves
Starting Member
4 Posts |
Posted - 2008-02-15 : 11:34:11
|
| Has anyone been able to use the Copy Database Wizard to copy a database from one sql server to another sql server without the server (2003) being on a domain? Thanks! |
|
|
|
kselves
Starting Member
4 Posts |
Posted - 2008-02-15 : 12:08:55
|
| Looked into the import database section, and am able to copy from the source database. Thanks! |
|
|
|
|
|
|
|
|
Copy Database Wizard Permissions