The maintenance plans will always look in the system tables for backup file names when cleaning up old data. The only way to delete old backups without affecting the system...

I know a SAN admin who holds on to information like a Scottish miser holds on to money. Anytime he's asked a question about setup, his first response is "Why?...

Ahh. For some reason all the SANs I've come across use multiple disk controllers. I've never heard of one with only one controller, unless the SAN used logical drives only...

Lynn Pettis (4/27/2010)

---

Sounds like all you may have restored is the production database. Did you setup the logins/users as they were setup on the hosted system? It sounds...

Grant Fritchey (4/27/2010)

---

Brandie Tarvin (4/27/2010)

---

If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing a...

homebrew01 (4/27/2010)

---

Brandie Tarvin (4/27/2010)

---

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken....

What is Data Provider "MSDASQL"?

I've never heard of this one before.

I'm glad it's working now. Sounds like the filename was kept in a table and re-running might have cleared the cache.

Well that seems to be the problem right there. The job is failing by trying to delete a file that doesn't exist.

Perhaps you should check the job, see if...

Does that file even exist? If so, is it perhaps locked by another process?

Could be several issues. Do you have access to SSMS?

Check to make sure the recovery actually recovered the schema and the objects involved. Check to make sure the user hasn't...

Create an Active Directory security group, add the users to the group, then give the group the necessary permissions. This way, when a user leaves or joins, all you have...

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken. The system tables...

SQL 2k5 has dropped support for a lot of the older or "other" database types in linked server OLE DB availability. Also in SSIS, unfortunately.

If you don't have a Teradata...

If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing a bit. But this is...