Home > Archive > MS SQL Server > November 2006 > SQL 2005 error while trying a copy databse action.









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQL 2005 error while trying a copy databse action.
Fernando Morais

2006-11-09, 7:13 pm

Hi,

I was trying to do a copy of a database, from a server to itself
creating a database with a different name.
But when i got to the "Configure the Package" page i got this error message.
It let me continue after i click ok but i receive the same error at the
end when it starts the action.
No other log is created, and i can't get enought data to debug why this
is happening.
Does anyone have any information that could help resolve this issue?

Thank you.

PS: I've attached the message text.


TITLE: Copy Database Wizard
------------------------------

One or more arguments are invalid


------------------------------
BUTTONS:

OK
------------------------------
Fernando Morais

2006-11-09, 7:13 pm

More detailed message text:

====================
===============

One or more arguments are invalid
(Copy Database Wizard)

------------------------------
Program Location:

at
Microsoft.SqlServer.Dts.Runtime.Application. FolderExistsOnSqlSer
ver(String
strFolderName, String strServerName, String strServerUserName, String
strServerPassword)
at
Microsoft.SqlServer.Management.CopyDatabaseWizard.PackagePage. EnsurePackageFolderE
xist(String
folderName, Application app, String serverName, String loginName, String
password)
at
Microsoft.SqlServer.Management.CopyDatabaseWizard.PackagePage. GetUniquePackageName
()




Fernando Morais wrote:
> Hi,
>
> I was trying to do a copy of a database, from a server to itself
> creating a database with a different name.
> But when i got to the "Configure the Package" page i got this error
> message.
> It let me continue after i click ok but i receive the same error at the
> end when it starts the action.
> No other log is created, and i can't get enought data to debug why this
> is happening.
> Does anyone have any information that could help resolve this issue?
>
> Thank you.
>
> PS: I've attached the message text.
>
>
> TITLE: Copy Database Wizard
> ------------------------------
>
> One or more arguments are invalid
>
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------

Tracy McKibben

2006-11-09, 7:14 pm

Fernando Morais wrote:
> Hi,
>
> I was trying to do a copy of a database, from a server to itself
> creating a database with a different name.
> But when i got to the "Configure the Package" page i got this error
> message.
> It let me continue after i click ok but i receive the same error at the
> end when it starts the action.
> No other log is created, and i can't get enought data to debug why this
> is happening.
> Does anyone have any information that could help resolve this issue?
>
> Thank you.
>
> PS: I've attached the message text.
>
>
> TITLE: Copy Database Wizard
> ------------------------------
>
> One or more arguments are invalid
>
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------


I can't help with this specific error, but I will suggest that you look
into using BACKUP and RESTORE to do this, it's far easier and much quicker.



--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com