Viewing 15 posts - 16 through 30 (of 58 total)
We have started doing that already, using the Quest Central tools. However, I wanted to better understand the statistics eg : if a particular job is taking x amount of...
October 10, 2006 at 7:58 pm
"You do development on your production machines?"
No, they don't do development on production machines, they only troubleshoot in the production environment.
September 19, 2006 at 5:38 pm
I would never change anyone's access without request from management. The only problem was that these guys have been running everything under the sa user. So, when the new server...
September 19, 2006 at 5:32 pm
As you all suggested, I did not set any max memory limit for my server with 2GB of RAM.
This is just the first day, and it is using 1.88GB...
September 17, 2006 at 9:05 pm
Mitchell, Thanks guys I understand that the SQLserver2000 Entyerprise Edn with 4GB of RAM deosn't need any other setting.
What about the SQL server 2000 Standard Edn with 2GB RAM. Do...
September 15, 2006 at 4:27 am
Yep, for the 4GB server, we are using Enterprise Edition, and the 2GB is standard Edition.
The guys mentioned that they had set the SQL server to fixed memory of 1.7...
September 15, 2006 at 3:18 am
We had this happen to one of our server once, and we found out that the Log file was full, and could not autogrow.
So, check that as well.
September 15, 2006 at 3:14 am
Thanks for your help guys. I've tried a few of these now.
Btw, Phill, it is great that I can see which connection is using what details in each DTS. How...
September 15, 2006 at 2:37 am
How many of you acting as DBAs are either domain admins or have local admin rights on your sql servers? Are you part of the regular 'systems team' -- that...
September 13, 2006 at 5:33 am
Thanks, I will do that to the databases that can be backed up.
However, what about the ones that can't be backed up. (These are too big, no room left on...
September 12, 2006 at 7:40 pm
Thanks carolyn. I was able to restore 1 database successfully. So, the other one was still marked "suspect". I wanted to test if the reboot would cause a problem again,...
August 31, 2006 at 3:34 am
Thanks Paul. I would really appreciate if you could show me a sample encrypted batch file with the DTSRun command.
Also, does that mean that the SQL server agent schedular can't...
August 31, 2006 at 3:02 am
Thanks Guys. You made it so easy . I'll give that a go.
August 28, 2006 at 7:19 pm
Thanks Guys, I don't know what I would've had done without your help.
Now my boxes have arrived, and the I've started testing, but I have left clustering for later,...
August 28, 2006 at 1:13 am
Viewing 15 posts - 16 through 30 (of 58 total)