I am on two Win2k Machines trying to copy a SQL database from one to the other. Machine A is here. Machine B is remote, and I am connected through a vpn.
I am using remote control software to access Machine B. I am using the Enterprise Manager on Machine B to run the copy wizard. Enterprise Manager can connect and has both Databases within it.
Both machines have the same user/pass for windows and the SQLServer service is using that same administrator login as well.
Here is how it goes:
-- Successfully created share OMWWIZC
-- Begin to copy database Dynamics
-- Database Dynamics has no active connections
-- Put the database Dynamics into single user mode
-- Try to detach DB
-- Successfully detached
-- Failed to copy file \\BZITZOW\OMWWIZC\Program Files\Microsoft SQL Server\MSSQL$ACCOUNTING\Data\GPSDYNAMICSDat.mdf
It failes consistantly at that step for every database that it is trying to copy. Here are more stats on my machines:
Machine A
Comp Name = BZITZOW
SQL Server Service = MSSQL$ACCOUNTING
SQL Server = BZITZOW\ACCOUNTING
MACHINE B
Comp Name = ACCOUNTING
SQL Server Service = MSSQL$GP
SQL Server = ACCOUNTING\GP
I have created the directories in both machines where the *.mdf files would be if the db names were the same. no help there. I guess next i will attempt to xfer it using the Enterprise Manager on Machine A.
*shrugs*
I am newbie to SQL Administration, any and all help available is GREATLY appreciated! Thanks!
I am using remote control software to access Machine B. I am using the Enterprise Manager on Machine B to run the copy wizard. Enterprise Manager can connect and has both Databases within it.
Both machines have the same user/pass for windows and the SQLServer service is using that same administrator login as well.
Here is how it goes:
-- Successfully created share OMWWIZC
-- Begin to copy database Dynamics
-- Database Dynamics has no active connections
-- Put the database Dynamics into single user mode
-- Try to detach DB
-- Successfully detached
-- Failed to copy file \\BZITZOW\OMWWIZC\Program Files\Microsoft SQL Server\MSSQL$ACCOUNTING\Data\GPSDYNAMICSDat.mdf
It failes consistantly at that step for every database that it is trying to copy. Here are more stats on my machines:
Machine A
Comp Name = BZITZOW
SQL Server Service = MSSQL$ACCOUNTING
SQL Server = BZITZOW\ACCOUNTING
MACHINE B
Comp Name = ACCOUNTING
SQL Server Service = MSSQL$GP
SQL Server = ACCOUNTING\GP
I have created the directories in both machines where the *.mdf files would be if the db names were the same. no help there. I guess next i will attempt to xfer it using the Enterprise Manager on Machine A.
*shrugs*
I am newbie to SQL Administration, any and all help available is GREATLY appreciated! Thanks!
