Use T-SQL to restore the database using the 'MOVE' option.  See 'How to restore files to a new location' in BOL.

Greg

Yes, if you do full backups only on Sunday morning.  Maybe you could schedule your reindexing to occur before the weekly full backup?

Greg

Are you rebuilding indexes on Sunday?  That would cause a lot of changes to extents as stuff is moved around in the data file.

Greg

Jeetendra,

There's a special page within each data file called a Differential Changed Map (DCM) page that keeps track of which extents in the file have been modified since the last...

Are you useing a Transform Data task to import the data?  If so, uncheck Use fast load on the Options tab of the task properties.  Bulk-copy, by default, won't fire...

I don't think so.  You could use UDL files for your connections then you'd only have to change the password in the file without opening the packages at all.  You'd...

So, you're saying that the job hasn't even run?  If there's no job history, I don't think the job is starting.  Make sure the job and schedule are enabled.

Greg

Glad I could help, Oscar.  Good luck!

Greg

I think you're stuck with trying to passing a global variable indicating success or failure from the child package to the parent package.  See Robert Marda's reply in this thread:...

Is the package actually being executed?  What do you see in the job history and package log?

Greg

Have you tried turning on package logging?  That could show you what's happening when the package executes.  Turn on logging on the 'Logging' table of Package properties.

I don't know much...

A single DTS package can handle it.  If it's a one-time thing, I'd use the Import/Export wizard.  If you want to save a package and run it repeatedly, you're better...

Did the child package actually fail?  If it continued running and completed successfully, the parent package would complete successfully.  You might try setting the 'Fail package on first error' property...

Kavita,

I replied to you post in the DTS forum.

Greg

If you turn on logging in the package, it will log each step and tell you which one failed.  In the event of a timeout, you'll see which step was...