darrylms (10/6/2009)

---

Some of the users created a new work area in one of their apps. The app decided to generate another DB for this.

I became involved when I was...

So, ServerA backs up across the network, to ServerC and fails, but ServerB backs up across the network to ServerC and is OK ? Did you test general ServerA...

Or even re-save it as-is and see if that fixes it.

While you are figuring it out, be sure to create a new job to do the backups.

Is the job enabled AND the schedule enabled ?

I now seem to remember using Lumigent Log Explorer for something like this .... I think it built insert statements based on the deletes that occurred so you could recover...

Would a log reader tool be usefule for extracting transaction information if a full backup was taken, and log backups have been taken, but the full backup no longer exists...

You could run something like this to get a listing of your backup history. Then you can see if you are missing any differentials or transaction logs:

SELECT sysdb.name,...

dba_pkashyap (9/24/2009)

---

Hi there,

one of our prod db is hosted on an external server.DB regular maintenance plans are all set and fine.

They do a system NT backup and IIS backup on...

I hope you're running backups every day right now.

Sergey's suggestion of a 3rd party tool is good. They compress to about 20% of original size (depending on your data) and are faster than native SQL backup. Then you...

I don't know about SSIS, but DTS allowed you to set a batch size. I used to do this for large imports and it seemed to process faster and hang...

EXEC msdb.dbo.sp_send_dbmail

Steve Jones - Editor (9/22/2009)

---

There are tools like Quest's Spotlight (or Foglight) and maybe Patrol from BMC, that will monitor this.

The way I used to do it was track backup...

Right click "Databases" -> "Attach" -> Select path to database files .mdf & .ldf

Edit: beat me by a minute !