Is there a recommended amount of free space in a database? We have a 50GB DB with 15GB free. Can we recover some of this without impacting...
Thanks, I will follow that procedure. Should I leave some extra space beyond what the typical maximum appears to be?
We backup the tlog every 2 hours between 6:00 am and 8:00 pm. I will look into backing up in 1 hour increments. Are you recommending setting a max...
No replication. We want log backups so we could restore in the middle of the day. Yes, our app does have some long transactions that hit many...
Thanks, That brings up the issue of why our log gets so big so fast. The mdf file is about 9G. After just a couple of days the log gets up to about...
I can't figure out when is the best time to shrink the tlog. Naturally after business hours, but how does it relate to ability to recover? Here is...
On SQL2000 we have several DB of about 7 GB and the t-logs are about the same size. How can we keep the log size down to conserve disk space? What we...
No policies, this was a vanilla machine up until SQL install. Applying the cumulative SQL patch seemed to finally make the remaining errors go away....
Any special considerations installing SQL 2000 Standard on Win 2003 Enterprise? I just did this and it corrupted the NIC driver or IP stack (still...
Thanks for all your help. I have a much better understanding now. I'm relatively new to SQL and expect to get much use from this forum.
I get 3,802,196k both with and without the /3GB switch. I would expect 4.1 GB or so. It would seem I'm not getting about 200MB. I get similar...
Even without the /3GB switch the OS reports about 3.6 GB of RAM. I get this number from My Computer/Properties. Adding the /PAE switch makes this...
Thanks, I think I understand the need for the /3GB switch better now. Any thoughts on why the OS does not see all the RAM unless I use the /PAE...
I thought the /3GB switch reserved 3 GB for applications and 1 GB for the OS?
Understood that standard edition uses only 2GB of RAM. Since this is a dedicated SQL server, do I gain anything by using the /3GB switch? Also, why...
I've had this issue on 3 new Intel server boards lately. Using WS2k3 Standard, SQL2k Standard. Machine has 4GB RAM. OS sees only 3.3 to 3.8 GB of RAM...
Separate names with a comma.
