If you think the design of this one is bad, you should see another system that is currently up for rewrite. Started in Access, ported to SQL backend but still...

OK, I'm really confused. Do you want to increase memory or eliminate the log full alerts?

yulichka (9/19/2008)

---

There is one server contains no maintance job and temp is 9MB and server has 3583 memory , change temp to 500MB? and there is another server that...

When the maintenance job runs it'll use tempdb. 9 Mb (and even 213 Mb) seems awful small for a tempdb. Mine average 5Gb. I guess it depends on your server...

Thos are demo alerts that come with the insatll of SQL. Did you actually get an alert? msdb, by default, is set to simple recovery mode. Tempdb is you workhorse....

My company uses Backup Exec and I dislike it. It was in place when I started and they will not change it. It works fine but for restore purposes, it...

I use the maintenance plan wizard (I know some people don't like MP). Obviously, the first thing to do is schedule full backups. Once you have that going, determine which...

Search engines are your friend...Here is but one hit via Google

http://kbalertz.com/264474/System-Database-Backups-Cannot-Restored-Different-Build-Server.aspx

stephane (5/26/2008)

---

:cool:Not sure why this is happening --- hoping someone can help me with this very simple coding issue:

I'm trying to update my company table with a member table field....

DNA is absolutely spot on. One reason to avoid the smaller autogrows is disk level fragmentation of your database. Using disk dfrag will help but the database should be offline...

Are you absolutely certain the log hasn't grown to some enormous size, preventing it from backing up to the share? See David O's reply....

The error is pretty specific. How big is the database, including the log?

"Stickys" are fine, if people read them (see posting recommendations). A simple search would yield volumes of information about why it's not recommended to do backups across the network, but...

All you need to do to see Brad is watch the advertisements on this site. I don't know how current it is but Brad's always there smiling....My math teachers were...

Believe me, you'll find plenty of help here. As I stated, and I think most posters will agree, if you show an effort, and show what you've done so far...