"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:eMKFbgsjEHA.3428@TK2MSFTNGP11.phx.gbl...
>I personally never use this task as I find that if I do think I need to use
> it then BACKUP RESTORE is ar quicker. The errors you get with this task
> are
> almost always to do with permissions and or taking over local users to a
> remote server.
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Jim Moon" <jmoon()at()uab.edu> wrote in message
> news:%23JsCZWsjEHA.3712@TK2MSFTNGP15.phx.gbl...
>> Why does DTS always break when copying all objects and data from one
>> database to another?
>>
>> It doesn't seem to matter which version of SQL Server, which server,
>> which
>> server OS, which settings, which anything ...
>>
>> Title Bar:
>> "DTS Import/Export Wizard"
>> Message:
>> "Failed to copy objects from Microsoft SQL Server to Microsoft SQL
> Server."
>>
>> Jim
>>
>>
>
>

"Jim Moon" <jmoon()at()uab.edu> wrote in message
news:%23JsCZWsjEHA.3712@TK2MSFTNGP15.phx.gbl...
> Why does DTS always break when copying all objects and data from one
> database to another?
>
> It doesn't seem to matter which version of SQL Server, which server, which
> server OS, which settings, which anything ...
>
> Title Bar:
> "DTS Import/Export Wizard"
> Message:
> "Failed to copy objects from Microsoft SQL Server to Microsoft SQL
Server."
>
> Jim
>
>

"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote
in message news:OQVEN43jEHA.3896@TK2MSFTNGP15.phx.gbl...
> Hi Jim,
>
> If you use this task, uncheck "Use default options", click the Options...
> button and uncheck "Copy database users and roles" and "Copy object level
> permissions" (alternatively you can check "Copy SQL Server logins",
> depending on what you want.)
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
> "Jim Moon" <jmoon()at()uab.edu> wrote in message
> news:O5QV82sjEHA.632@TK2MSFTNGP12.phx.gbl...
>> Thank you for the feedback, Allan.
>>
>> My goal of the moment is to create a new database, and then make all of
>> its objects and data exactly the same as another database in the same
>> instance of SQL Server.
>>
>> In my situation, I have difficulty thinking that it may be a permissions
>> problem, since I have all available administrative privileges.
>>
>> "Backup and Restore" will work. I was just wondering why DTS cannot
>> handle this.
>>
>> Jim
>>
>>
>>
>> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
>> news:eMKFbgsjEHA.3428@TK2MSFTNGP11.phx.gbl...
>>>I personally never use this task as I find that if I do think I need to
>>>use
>>> it then BACKUP RESTORE is ar quicker. The errors you get with this task
>>> are
>>> almost always to do with permissions and or taking over local users to a
>>> remote server.
>>>
>>> --
>>> --
>>>
>>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>>> www.SQLDTS.com - The site for all your DTS needs.
>>> www.konesans.com - Consultancy from the people who know
>>>
>>>
>>> "Jim Moon" <jmoon()at()uab.edu> wrote in message
>>> news:%23JsCZWsjEHA.3712@TK2MSFTNGP15.phx.gbl...
>>>> Why does DTS always break when copying all objects and data from one
>>>> database to another?
>>>>
>>>> It doesn't seem to matter which version of SQL Server, which server,
>>>> which
>>>> server OS, which settings, which anything ...
>>>>
>>>> Title Bar:
>>>> "DTS Import/Export Wizard"
>>>> Message:
>>>> "Failed to copy objects from Microsoft SQL Server to Microsoft SQL
>>> Server."
>>>>
>>>> Jim
>>>>
>>>>
>>>
>>>
>>
>>
>
>

"Jim Moon" <jmoon()at()uab.edu> wrote in message
news:O5QV82sjEHA.632@TK2MSFTNGP12.phx.gbl...
> Thank you for the feedback, Allan.
>
> My goal of the moment is to create a new database, and then make all of
> its objects and data exactly the same as another database in the same
> instance of SQL Server.
>
> In my situation, I have difficulty thinking that it may be a permissions
> problem, since I have all available administrative privileges.
>
> "Backup and Restore" will work. I was just wondering why DTS cannot handle
> this.
>
> Jim
>
>
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:eMKFbgsjEHA.3428@TK2MSFTNGP11.phx.gbl...
>>I personally never use this task as I find that if I do think I need to
>>use
>> it then BACKUP RESTORE is ar quicker. The errors you get with this task
>> are
>> almost always to do with permissions and or taking over local users to a
>> remote server.
>>
>> --
>> --
>>
>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> www.SQLDTS.com - The site for all your DTS needs.
>> www.konesans.com - Consultancy from the people who know
>>
>>
>> "Jim Moon" <jmoon()at()uab.edu> wrote in message
>> news:%23JsCZWsjEHA.3712@TK2MSFTNGP15.phx.gbl...
>>> Why does DTS always break when copying all objects and data from one
>>> database to another?
>>>
>>> It doesn't seem to matter which version of SQL Server, which server,
>>> which
>>> server OS, which settings, which anything ...
>>>
>>> Title Bar:
>>> "DTS Import/Export Wizard"
>>> Message:
>>> "Failed to copy objects from Microsoft SQL Server to Microsoft SQL
>> Server."
>>>
>>> Jim
>>>
>>>
>>
>>
>
>