BTW - updates to windows server and IIS primarilly help with process isolation such that websites that crash will not break IIS or other websites. Win 2008 by far is...

I'd be very surprised if SQL 2005 Report services was not supported in Win 2000 server. If this was the case I think the install program would have caught this....

Dom here's another thing. You have a service acount running the report server (probably nt Authority\System) in your ReportServer database you MUST have that service account as a user....

Dom, check out those exceptions and notice the named pipes and shared memory parts of the message. It appears the the transport level connection types need to be tweaked...

You can debug stored procs but you MUST have the right version of Visual studio and I believe its the standard or professional version. The out of the box SQL...

The path is not the same as the name. Can you connect to the DB using SQL EM?

If not you may need to do this via a system stored...

Thanks Perry and Jamie,

I've got this solved somewhat. Here's the explanation. The backup agent for disk file backups triggered something in the Volumne Shadow Copy (VSS) service that generates backup...

It now appears that I have phantom backups generated from an unknown source. The backups that create problems with the virtual device are not executed by the SQL agent jobs...

not snapshots in the technical sense for SQL Server 2005, but we do update the laptops with our applications. I find its much easier to perform a backup / restore...

I totally agree Krishna. My sales people get reqular upates to the DB, but we never bother with the log files, it's just another thing that may slow...

Guys and Gals, if you read between the lines in the original post they put the app on the "Sales Guy's" laptop. Most likely its for customer demos and they...

Thanks Francis you save me tons of time,

SQL logs show "Database backed up: ......" and it looks fine.

select Physical_Device_name

from msdb.dbo.backupmediafamily

where Physical_Device_name like '{%'

Returns about 1400 rows of stuff. While a...

Jessie, I did some searching and found that you should add a param to the sp_spaceUsed proc. This will give you a more accurate value.

EXEC sp_spaceused @User_Table_Name,'true'

I...

Jessie, thanks very much for this, but I found something rather interesting, perhaps you can explain.

The query identified a table with row count = 154 and phys_size_KB = 26760....

There is a config file in the reporting services directory. C:\program files\Microsoft SQL Server\MSSQL.x\reporting services\...

Browse around here and our will find the directory for the log files, config files, etc....