This subject was in discussed in this forum just a couple of weeks ago.  Check this: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=165246

Greg

I agree with Frank.  This has been done before.  Consider log shipping or replication for close-to-real-time data movement or DTS for more infrequent movement.

Greg

Basically, you need to backup the current active log file so you'll have it available to restore after the older backups.  Like Martin said, it depends on what was damaged.

Greg

Sounds like you might need a log reader tool like Log Explorer or PI Log.

Greg

See responses to your other thread.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=168218

SA may not be the only login that can perform a backup.  Backup permissions default to members of the sysadmin server role and the db_owner & db_backupoperator database roles.  If...

Our DBA group members are members of Local Administrators on the servers that have SQL Server on them.  We find it necessary for installing SQL Server and it's components, viewing...

Tom,

You're on the right track.  When Nic said to right-click on the SQL Server, he meant you should right-click on a specific instance of SQL Server.  Expand Microsoft SQL Servers,...

In Enterprise Manager, right-click on Data Transformation Services, click Open Package..., select the .dts file and it will open in DTS Designer.

Greg

This could be the bug mentioned in this KB article. http://support.microsoft.com/default.aspx?scid=kb;en-us;302621

Another thing that occurs to me is if 'Delete rows in destination table' or 'Drop and recreate destination table'...

What you're describing sounds like a logical backup device with the backup set appended each time a log backup runs.  I believe you have to specify which backup set you want to restore...

I hope that works for you.  I suspect that if your administrators won't make you a member of sysadmin, they might not want to create a proxy account to let you run...

You can also group servers in the EM tree.  Then you can expand each group or collapse each group.  I have groups called 'Dev Servers' and 'Prod Servers'.  Right click...

Matthew,

Is the problem that you can't create the job or that you can't start the job once it's created? 

Can you describe what your DTS package is doing?  Does it import...

There is not a way to hide database names in Enterprise Manager.  See this earlier thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=9669

Greg