Transfer SQL Server Objects Task - Why does it try to drop logins

This is a discussion on Transfer SQL Server Objects Task - Why does it try to drop logins within the sqlserver-dts forums in Microsoft SQL Server category; My ultimate goal is to use the Transfer SQL Server Objects Task to copy schemas only (no data) all the objects (tables, procedures, views, etc.) from a very large (100 GB+) database to another database for the purpose of log shipping this small database to a disaster recovery site. I actually plan to also copy small lookup tables in the smaller database. That's my goal, but I'm taking little steps first by using a test database with one small table to copy to another empty test database. Now....the problem. In the task editor, I enabled the following ...

Go Back   Database Forum > Microsoft SQL Server > sqlserver-dts

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-22-2008, 05:17 PM
Default Transfer SQL Server Objects Task - Why does it try to drop logins

My ultimate goal is to use the Transfer SQL Server Objects Task to copy
schemas only (no data) all the objects (tables, procedures, views, etc.) from
a very large (100 GB+) database to another database for the purpose of log
shipping this small database to a disaster recovery site. I actually plan to
also copy small lookup tables in the smaller database. That's my goal, but
I'm taking little steps first by using a test database with one small table
to copy to another empty test database.

Now....the problem. In the task editor, I enabled the following properties:
DropObjectsFirst
IncludeExtendedProperties
CopySchema
IncludeDependentObjects
CopyAllObjects
CopyTiggers
CopyPrimaryKeys
CopyForeignKeys
CopyData - False ( I don't want to move data, just empty objects)

This is a bit of overkill for my little test database with one table having
10 rows, but more aligned with my ultimate goal. So far so good.

When I run this, I receive the following error:

SSIS package "Package.dtsx" starting.
Error: 0xC002F325 at Copy Test, Transfer SQL Server Objects Task: Execution
failed with the following error: "ERROR : errorCode=-1073548784
description=Executing the query "IF EXISTS (SELECT * FROM
sys.server_principals WHERE name = N'fakelogin')
DROP LOGIN [fakelogin]
" failed with the following error: "Could not drop login 'GLADCTEL' as the
user is currently logged in.".

The "fakelogin" above doesn't even have access to this test database. Why
would SSIS try to drop this login, or any login for that matter? I would
like to copy users, roles, and permissions eventually, but I did not enable
these options yet.

I've Googled but can't spot this exact problem. I saw plenty of other
problems about this task though, and they don't leave me feeling warm and
fuzzy about this task.

Thanks in advance for any help.
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:52 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.