Viewing 15 posts - 106 through 120 (of 133 total)
Michael,
It may not be the case if you have that much memory...but most people only enable /3GB if they have 4Gb RAM and want SQL to address more than the...
July 7, 2009 at 8:13 am
Your settings are correct (in my opinion). I have seen some DBAs increase the minimum memory per query setting, but if there are many connections you can face memory pressure...
July 7, 2009 at 6:05 am
You are probably better turning off /3Gb switch with that much memory. Why force the OS to only 1Gb?
ps. Every Microsoft SQL Server engineer I have spoken to has recommended...
July 7, 2009 at 6:02 am
You can script all the SQL agent jobs and run them against the destination server...
June 30, 2009 at 5:21 am
I think you will find most DBAs will use 2 files only (in their default filegroups) unless the database needs additional filegroups for performance (or other reasons).
We have used a...
June 23, 2009 at 6:19 pm
In my experience, you really need separate physical disks to take advantage of filegroups from a performance perspective...
June 23, 2009 at 7:41 am
What about discussing security implications? Such as:
Permissions required in SQL Server to execute
Where does the batch file live and what rights are required for the share?
How do you stop users...
June 5, 2009 at 5:53 am
May 29, 2009 at 9:27 am
Yes. As the poster above mentioned, you must create a profile in SQL Server (that has SMTP server name, port, authentication etc).
May 29, 2009 at 9:25 am
Have you made sure the port (25?) is open and available? You could run a telnet session to check...
May 29, 2009 at 8:09 am
You know, I was never a fan of open file SQL agents, until in my last job the RAID array died (twice!) and the parity was corrupted (or so I...
May 22, 2009 at 9:21 am
What if your hard drive crashes (or your RAID array)? You need to get your .BAK files to tape, or the network.
The other option is you use backup software...
May 22, 2009 at 8:17 am
I really think you need to post more information if you want people to help you...
We don't know if you are talking about an open file agent type backup (that...
May 20, 2009 at 8:10 am
This is a tape backup question, not SQL Server right?
Maybe better to ask Windows admins (rather than DBAs)? What backup software are you using anyway?
May 20, 2009 at 1:11 am
The account that runs the tape backup process will need sa rights in SQL Server if it needs to create a virtual dump device. Could that be the issue?
May 19, 2009 at 7:58 am
Viewing 15 posts - 106 through 120 (of 133 total)