You must restore a full database backup before you can restore either a differential or a log backup.  See "Designing a Backup and Restore Strategy" in BOL.

Greg

Donald,

If datefield in table xyz is defined as char(10), it's not a datetime column.  You'll have to convert today's date acquired getdate() to character to do the comparison.  While you're looking...

You can't restore a 2005 backup to a 2000 instance.  You might try using DTS.

Greg

We have a couple of databases like this.  Different sets of tables in the database are used by different groups of employees in the same division. 

We have an application...

I see you got a response in another forum: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=269019

Please don't cross post.

Greg

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

1.Run the package, either by starting the job or copying the DTSRUN line to a command prompt.

2.Then run this...

...also, what specific tasks are in the package and which task fails?

Greg

Is the database set to the Simple recovery model?

Greg

I've used this query:

-- search for string in stored procedures in DB

--

-- note: the reason this joins to a second instance of syscomments is to find cases where...

DTS package data is stored in the MSDB database so a backup of that backs up packages.  The drawback is when you want to restore a single package, you'll have...

I just remembered another thread I participated in and it had a couple of possible solutions for the encrypted package name problem.  I haven't tried either method so I can't...

What occurs to me is SA is a SQL Server login and you'd need to have a Windows network login to write to a file server.  Our jobs run as...

You could query the sysjobsteps table in msdb looking for a DTSRUN command.  Something like this:

select * from sysjobsteps

where command like 'DTSRUN%'

This will only help you if the DTSRUN command...

Cory,

I got this script from another thread on this site and it worked for me.  Thanks to Scott Coleman.

set nocount on

create table #owned...

Scroll to the right in the Process Info screen to the application each process is running.  You will at least see a process for your Enterprise Manager connection (MS SQLEM)...