Mani beat me to the link but in general, never put databases on your c: partition if you can avoid it. If possible, move tempb to it's own physical drive(s)....

They vary from around $800 USD to $1700 USD. Check out Quest, Idera and Redgate (which I think was the least expensive), to name a few. Typically, as has been...

Duplicate post - reference here:

http://www.sqlservercentral.com/Forums/Topic519683-266-1.aspx

And, very important, after you truncate the log, do another full backup

Check these out. Paul is the best when discussing corruption. It's definitely not the best scenario for you but may at least get you started.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104090

http://www.eggheadcafe.com/forumarchives/SQLServerserver/Jul2005/post23536458.asp

jjssilva (6/19/2008)

---

I'm afraid I can't run a Profiler on this Production DB. Just too big and I can't afford slowing down the processes at this time.

Will try to check the...

Steve, in your editorial you said,

"TechEd is still disappointing for me this year, with about 6000 people instead of the 11,000+ there has been in the past. That many people...

Is what you're looking for in BOL -> roles-Sql Server->predefined?? It describes server roles and fixed database roles.

In Excel, highlight your column, select data then text-to-columns. This fixed an issue I had trying to convert what Excel thought was a text field back to a date-time field....

And one thing I know is true (for SQL2K, anyway), SQL will size your files (.mdf, .ndf, .ldf) to be as big as the source database for the restoration process....

Check out backup databases, permissions in BOL. Lots of pros/cons of using them. They do allow passwords to prevent unauthorized restores using that file but will not prevent someone deleting...

If it is not in simple recovery mode, take a look at some of these. Seems like various issues will pop this message. Anything additional in the log or when...

Steve Jones - Editor (6/13/2008)

---

Honestly, I would get more disk, backup locally and then copy to a remote server.

My method of handling this in the past is to backup (full...

Whatever NETWORK account is running the the SQL server agent service needs, at minimum, write permissions to the share on the network. If you need to restore from there as...

Lynn Pettis (6/12/2008)

---

The answer to this is Yes and No. there are a few that I can talk to about almost anything, just as a friend. I actually...