What is 'dbEvt.dbo.DTA_Events_Log' ? Does it exist ? Is it an event log type table referenced in triggers and stored procedures ? Did it get deleted ?

When asking about 3rd party tools and their features, I think you should also ask the companies directly. They may have just added a feature that we are not aware...

Great reply, thanks !

We are not using replication, and I ran a string search in all the stored procedures, so I think I'm good. This is actually correcting a mistake,...

TheSQLGuru (5/29/2012)

---

A) your request(s) go WAY beyond a forum thread for help.

B) You MUST consider the new pricing of SQL 2012, which is PER CORE, often making it...

If you can be more specific about the business needs you can get more...

In a production environment, I do a FULL or DIFF every day, and Transaction log backups every 20 minutes. That gives pretty good disaster recovery, and prevents the transaction logs...

Thanks Lowell !

9.00.1399 is the RTM version, with no service packs. Why not apply current service packs ?

There could also have been table locks, so the SSIS package had to wait.

Reply removed.

The REPLACE function is another option.

Here's the 2005 version:

http://lmgtfy.com/?q=SQL+server+2005+Architecture

Add/Remove Programs ?

A good approach would be to read about it, maybe try it in a test environment, then come back here and post more specific questions.

Divine Flame (3/5/2012)

---

Backup history is stored in MSDB database. Check the backup_size column in BackupSet table for the database you are looking for. Compare today's backup size to 30 days...