Using TransferData

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Baker - 17 May 2007 23:59 GMT

Hi,

I've been trying to get a SQL Server database copied within the same server
instance for several days. SMO.Transfer is the closest thing I can find right
now but the TransferData method is failing. I've been chasing down errors in
the database and correcting them as I go but currently it's attempting to
create a ROLE that already exists and failing on that. I'm not certain if I
should be ignoring this error (or how to). Is there someone that is actually
using TransferData? I also tried Backup and Restore class objects too. I got
as far as SqlRestore and it tells me that it can't becuase the files are in
use - of course they're in use, SQL server is using them. I'm finding it
difficult to find any samples that do what I want.

TIA
Mike

Reply to this Message

Mike Baker - 18 May 2007 01:44 GMT

PS - Sorry if this isn't the right group. Can't find one for the SMO (Sql
Server Management Objects) sdk

> Hi,
>
[quoted text clipped - 11 lines]
> TIA
> Mike

Reply to this Message

Charles Wang[MSFT] - 18 May 2007 08:38 GMT

Hi,

Thank you for posting here!

However, I notice you have posted the same question in our SQLServer
newsgroup, which I have already responded. So please check my answer there
and if you need any further assistance on this particular issue, please
reply to me in that thread so I can follow up with you in time.

Thank you and Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Reply to this Message

Rate this thread:

Using TransferData

Free Magazines