Hello there

I've created dts that sends data from one server to another

I got an error: BACKUP LOG permission denied in database 'destination
database'

Whad is wrong?

Any help will be useful

Are you using the Copy SQL Server Objects task? And what
service pack?
There are some issues with the task and it varies depending
upon what service pack you are on.
You can get around this by having the package create the
desired objects and then use the transform data task to move
the data between the databases.
It's basically how the copy sql server objects task is
performed. You can find more information on it in the
following article which describes a different issue but it
explains what is going on in the process:
FIX: DTS Copy Objects Task (DMO) breaks transaction log
backup chain by switching recovery mode to Simple during
transfer
http://support.microsoft.com/?id=308267

-Sue

On Wed, 9 Feb 2005 15:15:32 +0200, "Roy Goldhammer"
<roygoldh (AT) hotmail (DOT) com> wrote:

Whell Sue

It seems that i need to change the recovery mode to somthing else.

How can i do this?
"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

No address this problem (if you are using the Copy SQL
Server Objects task), you don't necessarily need to change
the recovery model. The recovery model should be based on
business needs and your backup/recovery strategy.
However, to change the recovery model, you would use:
alter database <YourDatabase>
set recovery <YourRecoveryModel>

-Sue

On Thu, 10 Feb 2005 09:03:52 +0200, "Roy Goldhammer"
<roygoldh (AT) hotmail (DOT) com> wrote: