I'm in a similar situation, but I don't want to lose my FULL backup history because I find it useful to look at growth over time. T-Log backups take up...

Then I would think the next thing to do is look at the SP code, and the data coming in.

What are you trying to do ?

Did you search on "Null value is eliminated by an aggregate or other SET operation"

I found lots of hits, but not sure which...

The OP seems to be posting hastily without taking the time to properly explain the problem or the attempted solutions. If it's important, perhaps he/she will try harder.

Grant Fritchey (5/3/2010)

---

Just remember that backups are very largely a business driven decision, not strictly technology. Talk to the business side of the company to understand what their expectactions of...

You're in the 2005 forum, but I don't think that matters in this case, but some of us have not used 2008 so we might give the wrong answer if...

I just found this, so I guess I don't have SS Express: Looks like I need to enable Named Pipes

http://www.mssqltips.com/tip.asp?tip=1577

Problem

Microsoft products such as Windows Server Update Services (WSUS)...

"... Start >> All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager ..."

I just have "Windows Internal Database (MICROSOFT##SSEE)" ...

SQL Server Browser service doesn't show at all. I'm not familiar with the firewall settings that may be in place .... not much help :ermm:

I'm remotely logged onto the server itself. There is no browser service. The only services related to SQL are:

SQL Server VSS Writer.

I don't know how this was setup .... I...

I think you're right. Tried SERVER\INSTANCE and got a different error:

TITLE: Connect to Server

------------------------------

Cannot connect to SERVERNAME\MICROSOFT##SSEE.

------------------------------

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server....

4) The backup related tables in MSDB store information about the backups and restores that have taken place .... the history of activity. Not the actual backup data.

None of the...

Search "database growth" and you will find quite a few posts & scripts

jpSQLDude (4/28/2010)

---

Another question, if I may: if you look at that code I posted above, there is a simple command to list all the traces running on a server:...

striker-baba (4/28/2010)

---

Actually, My C drive is 40 gb ... and

I see some users have lots of data like around 11 gb of data on their personilized desktops...

I dont know...