October 4, 2012 at 2:38 pm
I'm trying to use the SQL Server 2008R2 Copy Database wizard to copy a couple of databases from one computer to another. (These are client data, and I want a copy on my notebook, so I can work on this project on the road.)
With some effort, I've gotten to the point of "Execute SQL Server Agent Job," at which point it fails. Examining the log file, I find this line:
OnError,[name of dest-server],NT AUTHORITY\SYSTEM,XXXX_Transfer Objects Task,{46B5C485-28C3-4DD4-858C-A62E87EA9AB5},{4D84AAB3-69EB-4BDE-BE51-FC9DEF614E3A},10/3/2012 2:50:16 PM,10/3/2012 2:50:16 PM,0,0x,Failed to connect to server [name of source server].
I'm using Windows authentication on both ends. I have no problem opening the source database in SSMS on the destination machine using Windows authentication.
Any ideas?
Tamar
October 4, 2012 at 4:22 pm
Is there any way that your connection could be getting interrupted? You mentioned that you're on a laptop, are you doing this over a wireless network?
October 4, 2012 at 4:40 pm
I dont use it as its a pile of doggy doo doo 🙂
What options are you using during the copy?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 4:41 pm
Grab a backup and restore it on your notebook? I hate that wizard, it's got so many danged little issues.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 5, 2012 at 7:56 am
I'm using a wired connection. I always try to do that when I need to copy large files.
October 5, 2012 at 8:02 am
Here's the summary I get from the wizard, with substitutions for some identifying info. Note also that "Zenbook" is a user I created on the source server to try to use SQL authentication instead of Windows authentication. Note sure why it shows up here at all.
-------
Click Finish to perform the following actions:
Source: [source machine] Other SQL Server Version, Microsoft SQL Server Enterprise Edition (64-bit) , Build 2500, Microsoft Windows NT 6.1 (7601) NT x64
Destination: [destination machine] Other SQL Server Version, Microsoft SQL Server Enterprise Edition (64-bit) , Build 2500, Microsoft Windows NT 6.1 (7601) NT x64
Using Attach/Detach offline transfer
The following databases will be moved or copied:
Copy:Refine
Destination file will be created: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\[database1].mdf
Destination file will be created: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\[database1].ldf
Stop transfer if duplicate database name exists at destination
Copy:refine_rrr
Destination file will be created: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\[database2].MDF
Destination file will be created: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\[database2].LDF
Stop transfer if duplicate database name exists at destination
Transfer the following database objects:
Logins used by selected databases (estimated)
##MS_PolicyEventProcessingLogin## => ##MS_PolicyEventProcessingLogin## (Already Exists)
[source machine]\Tamar => [destination machine]\Tamar (Already Exists)
Zenbook => Zenbook (OK)
Package scheduled to run immediately
October 5, 2012 at 8:03 am
Evil Kraig F (10/4/2012)
Grab a backup and restore it on your notebook? I hate that wizard, it's got so many danged little issues.
My understanding is that some stuff doesn't come along with a backup? Is that right?
Tamar
October 5, 2012 at 8:08 am
What sort of stuff wouldn't come with a full backup? That's sort of the idea of a backup - you get everything.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply