Friends,
I have very strange problem.
I have a DTS Package, which migrate data from one database to another
database after some validation.
Configuration :
-Sql Server 2000
-Working on Test Database Server
-2 GB RAM
The issue is, lastly the whole migration takes only 6 - 7 hours, but
now its not compelete after 24+ hours.
--Database is same.
--DTS package is same.
If any body has any idea, please reply me.
--Points to find the exact problem.Hi
What does the packaege do? Have you checked whether your db is growing
during the execution or not? What is recovery model of the database?
"Rahul" <verma.career@.gmail.com> wrote in message
news:1189486332.650922.89980@.o80g2000hse.googlegroups.com...
> Friends,
> I have very strange problem.
> I have a DTS Package, which migrate data from one database to another
> database after some validation.
> Configuration :
> -Sql Server 2000
> -Working on Test Database Server
> -2 GB RAM
> The issue is, lastly the whole migration takes only 6 - 7 hours, but
> now its not compelete after 24+ hours.
> --Database is same.
> --DTS package is same.
> If any body has any idea, please reply me.
> --Points to find the exact problem.
>
No comments:
Post a Comment