You could ask your network administrators if they took any backups, or even took backups of the disk where the database (.MDF) was. Maybe you will get lucky.

CirquedeSQLeil (9/11/2010)

---

Here's a shortcut to learn how to script those backups.

Through the gui, make the selections you need. Reassign the name, file names, and file locations as necessary. ...

Upgrading has been covered many times. You could search this site for "2000 2008 upgrade" and you will get a lot of information. Then maybe you can post more specific...

Does the package complete normally after 5 hours ? And if so, is the data as expected ?

The error sounds as though the job does not have permission on...

Edited my query to include recovery model.

Maybe something like this would help you see the backup status of all your databases:

-- Most Recent Backups and # of days since ANY type of backup

SELECT B.name as...

Instead of resurrecting a 2+ year old thread, I think it would be to everyone's benefit to start a new thread.

OK ... I think I have it .... I was looking at the "DestinationConnectionOLEDB" tab by mistake Thanks

I want to copy 40,000,000 records, so I'm setting the...

There's your...

Also, are you sure you want to overwrite the previous day's backup ? I like to have several days backups available in case I discover a problem from a...

When you see the blocking with SP_WHO2, look to see which process is at the root cause. So, if SPID 17 is blocked by SPID 23, look to SPID 23....

This doesn't directly answer your question, but, you could use a Maintenance Plan to control your full and transaction log backups and then use the cleanup task to easily control...

As mentioned already, log backups are critical. I do them every 15-30 minutes on production databases. That helps control the log size, and give you good point-in-time recovery options.

Raghavender (9/7/2010)

---

Perhaps it was initially set as a publisher, and the publication was not completely removed...

There have been several questions asked, that you have not answered, that might provide useful information.