dbTalk Databases Forums  

Reattaching Databases after Copy DTS package run

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Reattaching Databases after Copy DTS package run in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Paul Blackler
 
Posts: n/a

Default Reattaching Databases after Copy DTS package run - 08-13-2003 , 04:08 AM






Hi All
When I run the Copy Databases wizard to copy databases
between two servers, on the target and host servers all
databases after MASTER & MSDB need to be reattached.

We are running SQL 2000.

Look forward to a tip

cheers

Paul

Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: Reattaching Databases after Copy DTS package run - 08-13-2003 , 10:36 AM






You can setup the process to do more detailed logging so
that you can get more information on what's going on. You
can find information on doing this as well as
troubleshooting steps in the following article:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?id=274463

-Sue

On Wed, 13 Aug 2003 02:08:04 -0700, "Paul Blackler"
<pblackler (AT) themis (DOT) co.uk> wrote:

Quote:
Hi All
When I run the Copy Databases wizard to copy databases
between two servers, on the target and host servers all
databases after MASTER & MSDB need to be reattached.

We are running SQL 2000.

Look forward to a tip

cheers

Paul


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.