attach Database Error -very URGENT

hi to all
I got a probelm with attaching the database. I hv Database Name called "ABC". it is working fine. (contain MDF,LDF files)

I got new BackFiles from CLient. They sent MDF and LDF Files. But i could't able to attach the database i got the following error while attaching the databse.

Server: Msg 5173, Level 16, State 2, Line 1
Cannot associate files with different databases.

I tried with the following query

EXEC sp_attach_db @.dbname = N'ABC',
@.filename1 = N'C:\DataBase\ABC.mdf',
@.filename2 = N'C:\DataBase\ABC_log.ldf'

i Tried with EnterPrise Manager also i got the same error. you can see the attachment file to view the ERROR.

Please Help me .Urgently...http://support.microsoft.com/default.aspx?scid=kb;EN-US;281122 to resolve the issue.

Attach And Detach Replication

I would like to attach and detach my database due to change the log file
since that logfile already contain too large data.
But the problem occur, It's said that must drop the replication before do
any attach on that data .But i can't drop the replication since i still need
replicate the data from the other server back to local server.
so, anyone can give me any suggestion to do the attach withour drop the
replication?
For a supported solution, you'll need to disable replication before the
detach and attach
(http://msdn2.microsoft.com/en-us/library/ms188769.aspx). Ideally script out
the publication and do a nosync initialization if you can prevent any data
access.
For an unsupported solution that doesn't involve dropping the publication,
search this newsgroup for Ponnu...
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
"sam" wrote:

> I would like to attach and detach my database due to change the log file
> since that logfile already contain too large data.
> But the problem occur, It's said that must drop the replication before do
> any attach on that data .But i can't drop the replication since i still need
> replicate the data from the other server back to local server.
> so, anyone can give me any suggestion to do the attach withour drop the
> replication?
>
sql

Assigning the value of variables in a Subpackage

Hi,

I have a parent SSIS package that executes various subpackages. Each of the subpackages contain variables that are required for their successful execution, e.g. one has a variable of datetime datatype and a variable of varchar datatype.

This date will essentially change with every running of the package as it specifies the date that additional data has been added to the back-end SQL Server 2005 database.

I can't find anything in the expressions of the Execute Package Task that would allow me to pass these variables into the package.

Can anyone advise?

Thanks,

Paul

Look at the documentation of "Execute Package" task @. http://msdn2.microsoft.com/en-us/library/ms137609.aspx

Section on "Passing Values to Child Packages"

Hope this helps.

Thanks,
Loonysan

|||

Thanks Loonysan

I'll give it a go