Assuming all permissions are OK, I'd suspect anti-virus here as the file exists...and the OS says it doesn't...

Also have you tried the reboot & repair combo?

Thanks for replies 🙂 Is "post-sizing" possible?

If my largest DB is 50GB, will re-sizing the tempdb to 5GB be beneficial?

Thanks Roy.

Is SQL Profiler of use here in SQL 2005?

The below works!

SELECT AgentIP

FROM SCConfigMgmt.dbo.NODES CDB

RIGHT OUTER JOIN NetperfmonSC.dbo.NODES MDB

ON

CDB.AgentIP COLLATE Latin1_General_CI_AS = MDB.IP_ADDRESS

Thanks!

Now I have the following which, I believe, is unresolvable:

Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

Thanks for the reply!

I understand the idea here but HOW do I assign aliases?

Hi Greg, the database recovery model is set to simple.

Thanks for replies!

As far as I understand this: writes are committed to the transaction log and then to the database. This allows rollbacks of transactions.

Excuse my basic understanding here,...

Yes, it's a simple set of commands but that leads me to another question: I'd originally saved the backup job as a .sql file and ran it manually.

How can...

I think that's what I did but being a noob i'm not sure: does this look OK:

http://static.flickr.com/59/204019468_e0eeff1752.jpg?v=0

Apologies for external link but a picture = 1000 words.

Outstanding alzdba ! That's exactly what I was looking for 🙂