December 10, 2008 at 2:43 pm
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
December 11, 2008 at 10:40 am
If possible restart your sql server service
Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply