What CTP are you using?  I just ran selects on the sys.system views without any trouble.  This was with a regular user.  The public role has SELECT access on those views...

It probably is.  The entire toolset for SQL Server 2005 is based on Visual Studio 2005 now, so it wouldn't be surprising.  I just started messing around with the reports...

My understanding is that you need it installed in addition to Team Suite.  You actually got the VS 2005 install to work properly with the June CTP?

Did you try Visio?  It's not bad if you already own it.  If you have 300 tables, you might consider subject areas.  300 tables on a big .jpg is going...

There's no way to compress the data, except putting it on compressed file systems.  Don't EVER do this.  I don't know of any third-part software out there for this either.

If...

Look at the articleson http://www.sql-server-performance.com.  They have an audit checklist and several good articles about performance tuning.

Ok.  That's definitely weird.  I'm assuming you're on at least Service Pack 3.  You might want to check out Tara's scripts:

http://weblogs.sqlteam.com/tarad

I'm sure you'll get a lot of responses on these.  Here's a quick stab at them though.

1.  IF you had a failure during the middle of the full backup, you...

Were there any other errors in the SQL Server error log?  That one doesn't do us much good.  You might try to have more time between the backups and restores.

yaip, are you on the June CPT or April?

The sp_help_job procedure is pretty extensive on the information it can return.  If you look it up in Books Online, it details all the inputs and outputs.  Let us know if...

Have you tried to run a RESTORE VERIFYONLY on the database file to verify integrity?  You can find the syntax in BOL.  IF that works, try dropping the database files,...

What version/edition of windows and SQL Server do you have?

Here of course.

http://www.sqlteam.com

http://www.dbforums.com

http://www.sql-server-performance.com

The SQL Pass conference.

DICE???

What exactly are you looking for?

The web site leaders might want to consider moving SQL Server 2005 to the bottom of the forum list.    It looks like...