COpy Database

I ran the copy database wizard to set up a job to copy three dbs from one
server to another. The job copied two of the db's but not the third one.
It is possible that there was an open connection to that db. Will that
prevent a copy from executing? Also, it appears that this process is
accomplished by detaching the dbs as when I came in the two databases that
were copied were not reattached on the main server. Would the failure to
copy the other db prevent the reattach from executing?
Barry
looks like it didn't finishing attaching dbs. copy db wizard does detach and
attach the database. That's why I usually don't like to use it.
<barryfz@.home.com> wrote in message
news:ubR8Y%23zlEHA.396@.tk2msftngp13.phx.gbl...
> I ran the copy database wizard to set up a job to copy three dbs from one
> server to another. The job copied two of the db's but not the third one.
> It is possible that there was an open connection to that db. Will that
> prevent a copy from executing? Also, it appears that this process is
> accomplished by detaching the dbs as when I came in the two databases that
> were copied were not reattached on the main server. Would the failure to
> copy the other db prevent the reattach from executing?
> Barry
>
|||Hi Barry,
From your descriptions, I understood that your Copy Database Wizard failed
to transfer the third database while the first two succeed. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know.
Based on my scope, to avoid data loss or inconsistency, you must be sure
there are no active sessions attached to the database being moved or
copied. If there are active sessions, the Copy Database Wizard will not
run. You could also find the descriptions above in BOL, Using the Copy
Database Wizard. Which is to say it is entirely possible the active session
in your third database lead to that copy failure.
Additionaly, here are some documents for you on how to transfer databases
between SQL Servers.
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default...b;EN-US;224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default...B;en-us;314546
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Barry,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

COpy Database

I ran the copy database wizard to set up a job to copy three dbs from one
server to another. The job copied two of the db's but not the third one.
It is possible that there was an open connection to that db. Will that
prevent a copy from executing? Also, it appears that this process is
accomplished by detaching the dbs as when I came in the two databases that
were copied were not reattached on the main server. Would the failure to
copy the other db prevent the reattach from executing'
Barrylooks like it didn't finishing attaching dbs. copy db wizard does detach and
attach the database. That's why I usually don't like to use it.
<barryfz@.home.com> wrote in message
news:ubR8Y%23zlEHA.396@.tk2msftngp13.phx.gbl...
> I ran the copy database wizard to set up a job to copy three dbs from one
> server to another. The job copied two of the db's but not the third one.
> It is possible that there was an open connection to that db. Will that
> prevent a copy from executing? Also, it appears that this process is
> accomplished by detaching the dbs as when I came in the two databases that
> were copied were not reattached on the main server. Would the failure to
> copy the other db prevent the reattach from executing'
> Barry
>|||Hi Barry,
From your descriptions, I understood that your Copy Database Wizard failed
to transfer the third database while the first two succeed. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know.
Based on my scope, to avoid data loss or inconsistency, you must be sure
there are no active sessions attached to the database being moved or
copied. If there are active sessions, the Copy Database Wizard will not
run. You could also find the descriptions above in BOL, Using the Copy
Database Wizard. Which is to say it is entirely possible the active session
in your third database lead to that copy failure.
Additionaly, here are some documents for you on how to transfer databases
between SQL Servers.
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=KB;en-us;314546
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Barry,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Copy All Tables from Server A to Server B

I haven't had any luck using the Transfer SQL Server Objects task and from what I have found in researching the issues I ran into, no else has. I have found the Roll Your Own article but being non-educated in SMO and VB.Net (I know some VB but nothing about C#), I really need an example of a server to server copy/transfer.

Any help would be greatly appreciated.

Did you take a look at this link? It has VB code for copying a database: http://blogs.msdn.com/mattm/archive/2007/04/18/roll-your-own-transfer-sql-server-objects-task.aspx. To copy server to server, you'd just need to modify it to include a source and destination server.|||I know this will sound lame, but that's my problem. I haven't figured out how to add a source and destination server. I've never worked with this before and I haven't found any examples.

Convertion VarChar Error

Ive got a small problem at the moment

I have ran a query that has been used for a while now and have recieved this error

Server: Msg 245, Level 16, State 1, Line 3
Syntax error converting the varchar value 'N' to a column of data type int.

Ive searched the data and the only value of N that i can find is currently sitting in a field where the field type is varchar

is there a workaround for this, Ive tried running a case statement to set the N to 0 and also tried casting

Cheers in advance
Dave...the only value of N that i can find is currently sitting in a field where the field type is varcharso why is it trying to convert this value to an integer?

i have no idea, because i can't see your query from here

:)|||rudy man i thought you were psychic

-- 5302 MH consultant OP first attendances

SELECT CdsType,
NHSTrust,
AttendedOrDNACode, --N apears here varchar(1) column
FirstAttendanceCode,
SpecialtyCode,
Specialty,
PCG,
PurchCode,
datepart (year, ActivityDate) as yearAct,
datepart (month, ActivityDate) as monthAct

FROM dbo.VIEW_Outpatient2000_Analysis

WHERE PurchCode like '5KW%'
--pcg like 'Chelt%'
and NHSTrust not like 'Glou%'
and FirstAttendanceCode = 1
and AttendedOrDNACode in ('5', '6', '1','N')
and SpecialtyCode between '710' and '715'
and ((datepart (year, ActivityDate) = 2004
and datepart (month, ActivityDate) > 03)
or (datepart (year, ActivityDate) = 2005
and datepart (month, ActivityDate) < 04))

So im pretty much confused, cant see anything there that would cause a problem|||the 'N' may not necessarily be where you think it is

FirstAttendanceCode = 1|||Ah Blind as a Bat i am
Cheers rudy