You want to restore the full backup with NORECOVERY, then restore each of the log backups stopping at 10:00 AM.

Something like this:

restore database TestData

from disk = 'C:\TestData.BAK'

with NORECOVERY,

with move 'TestData_Data'...

Francis,

Can you tell us which DTS tasks you have in your package?  I sounds like you may be trying to use a precedence constraint between a task and a connection.  It...

What tasks are you using in the DTS package?

That will work if whomever created the job put in a description.  A job can be created without one.

There's no direct way to decrypt the DTSRUN parameters, but try this:

1.Run...

Designate the dsn in the connection object in the DTS package.  Double click the connection and specify the system dsn you created.

Greg

Paul,

Use the Copy tables and views option.  On the Column Mappings tab of the import wizard, you'll find a check box that says, "Enable identity insert".  Check the box and...

Helen,

This site: http://support.microsoft.com/common/international.aspx?rdpath=gp;%5Bln%5D;lifecycle provides the information you want.

Greg

Bradley,

If, as your subject suggests, you're trying to do this in Oracle, you don't have to use a function at all.  Just subtract the dates.  See this link:

http://asktom.oracle.com/~tkyte/Misc/DateDiff.html

Greg

Robert,

Right-click on the Bulk Insert task, select workflow, then workflow properties.  On the Options tab, make sure the checkbox for Fail package on step failure is cleared.  Also, on the...

It sounds like you're talking about what Microsoft calls a standby server using differential backups instead of log backups.  Check out "standby servers" in BOL. 

You're right that you can't restore another...

I do that as well as enable logging in the DTS package itself on the "logging" tab of package properties.

Greg

All of the ALTER permissions that I know of are not transferable, which means you can't grant permission to a user who is not a member of sysadmin, db_owner, or db_ddladmin.

Greg   

What message do you see in the SQL Server error log?

Greg

Francis,

This might be a dumb question, but are you sure the full-text population was completed before you ran your query?

Greg

Use a Transform Data task with your SQL Server table as the source and the Excel as the destination.  So, your DTS package will have a SQL Server connection, an...