Transfer Database Task Error

• r.southern

  SSC Rookie

  Points: 46

  More actions

  December 10, 2008 at 2:43 pm

  #129218

  Hello,

  I've been trying to get TDT to work for me for the better part of a day.

  My latest attempt does the following:

  - Drop database using "Execute SQL Task"

  - Run TDT with these settings:

  -- Source and Destination connections are the same

  (Both are logging in with the SA account on the same server)

  -- Destination database name is "ssis_dev"

  -- Destination Database files = "ssis_dev.mdf","c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA","\\t-1000\temp";"ssis_dev_log.ldf","c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA","\\t-1000\temp"

  (Network path is leftover from a previous attempt w/offline xfer)

  -- Destination Overwrite = True

  -- Action = "Copy"

  -- Method= "Online"

  -- Source Database Name= "ssis_live"

  I then got this error message:

  "The database principal owns a schema in the database, and cannot be dropped"

  It was looking at the "aspnet_Roles_FullAccess" in my database, so I deleted it, along with all other aspnet schemas.

  Afterward, I got this error:

  IF EXISTS (SELECT name FROM sys.databases WHERE name = N'ssis_dev')

  DROP DATABASE [ssis_dev]

  " failed with the following error: "Cannot drop database "ssis_dev" because it is currently in use."

  I changed overwrite to False, and still got the same answer.

  Anyone know what I'm doing wrong?

  Help would be much appreciated.

  Thanks,

  - Ray

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  December 11, 2008 at 10:40 am

  #911222

  If possible restart your sql server service

  Thanks