Copy Server problems

I've 7 regional production servers that I want to copy to another server
every night. Let's call the source production servers 1 through 7, and the
destination X.

Server 1 has links to server 2 through 6. Why? I'm not sure, I'm trying to
find out so I can delete them if possible

So, I made a DTS on X to copy a database from 1 to X. However, it throws an
error. Logging the DTS I get, I replaced the server name with *SERVER 1*.

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Could
not find server '*SERVER 1*' in sysservers. Execute sp_addlinkedserver to add
the server to sysservers.
Step Error code: 80041C22
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131


So until I can delete these links (not sure how to find out if they're being
used), how can I fix this? Do I need to make a link on server X as well?

Thanks,
Greg

Hi Gerg,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

Based on your description, you would like to copy databases from server 1-7
to server X. Is it correct? If I misunderstand anything, please let me
know. That will help us better understand the issue.

In order to address your concerns, I would like to explain the following
I) regarding to your description, some linked servers have created on the
server 1. We can find them by the following step
1. use SSMS connect to the server 1
2. expend server object->linked servers.

2 Based on the error message, the issue might to be related to how the DTS
is created. and it seems to require us to add server 1 as a linked server
on server X.

3 if you don't want to setup a linked server on server X, it is suggested
to use "COPY Database Wizard". On the server 1, right click the database
which you want to copy to server X ->Task->COPY Database

About "Copy Database Wizard", there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms183462(SQL.90).aspx

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg.DeleteThis@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 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. 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/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================