Viewing 15 posts - 1,066 through 1,080 (of 1,319 total)
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)....
-- You can't be late until you show up.
June 20, 2008 at 7:25 am
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...
-- You can't be late until you show up.
June 20, 2008 at 6:22 am
Duplicate post - reference here:
http://www.sqlservercentral.com/Forums/Topic519683-266-1.aspx
-- You can't be late until you show up.
June 19, 2008 at 2:48 pm
And, very important, after you truncate the log, do another full backup
-- You can't be late until you show up.
June 19, 2008 at 7:51 am
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
-- You can't be late until you show up.
June 19, 2008 at 7:18 am
jjssilva (6/19/2008)
Will try to check the...
-- You can't be late until you show up.
June 19, 2008 at 7:03 am
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...
-- You can't be late until you show up.
June 18, 2008 at 2:53 pm
Is what you're looking for in BOL -> roles-Sql Server->predefined?? It describes server roles and fixed database roles.
-- You can't be late until you show up.
June 18, 2008 at 1:14 pm
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....
-- You can't be late until you show up.
June 18, 2008 at 1:10 pm
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....
-- You can't be late until you show up.
June 17, 2008 at 8:32 am
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...
-- You can't be late until you show up.
June 13, 2008 at 8:26 am
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...
-- You can't be late until you show up.
June 13, 2008 at 8:18 am
Steve Jones - Editor (6/13/2008)
My method of handling this in the past is to backup (full...
-- You can't be late until you show up.
June 13, 2008 at 7:54 am
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...
-- You can't be late until you show up.
June 13, 2008 at 7:39 am
Lynn Pettis (6/12/2008)
-- You can't be late until you show up.
June 12, 2008 at 2:28 pm
Viewing 15 posts - 1,066 through 1,080 (of 1,319 total)