Viewing 15 posts - 8,941 through 8,955 (of 9,208 total)
DBCC LOGINFO should show the status of the log file.
August 21, 2008 at 4:24 pm
what is min memory set to on the instances?
August 21, 2008 at 4:22 pm
theres no point in RAID 10 for the OS thats just a waste of disks (these would be local disks anyway presumably).
Use RAID 1 for OS
all depends on how...
August 21, 2008 at 4:09 pm
Developer edition offers all the features of enterprise, as a developer you would want to use this edition (hence its name 😉 )
if you need a server installation to eventually...
August 21, 2008 at 1:12 pm
Thayal Muhunthan (8/21/2008)
We have 2XQUAD processors. Do we go for SQL 2005 standard or Enterprise ?
do you plan to use the Enterprise features or not, in most cases SQL2005...
August 21, 2008 at 10:02 am
GilaMonster (8/21/2008)I thought it was worth repeating and expanding on.
for sure, considering he still mentioned using it 😉
August 21, 2008 at 8:52 am
Wilfred van Dijk (8/21/2008)
AFAIK, you need to restart SQL in order to make these changes for @@SERVERNAME
yes that is correct
August 21, 2008 at 8:50 am
GilaMonster (8/20/2008)
You can't do Raid 10 (striped and mirrored) with only two drives. It requires a minimum of 4.
Gail i pointed this out already but he still plans to...
August 21, 2008 at 5:51 am
SQL Noob (8/20/2008)
this applies only to 32 bit versions
according to the MS features the only memory caveats are for 64GB RAM and above
SQL2005 Std however will support OS max RAM
August 21, 2008 at 5:47 am
windows authentication is a default, when you rebuilt did you script off any login info before hand? like sql logins, windows logins have to be added to the server too
August 21, 2008 at 5:38 am
Edwin (8/20/2008)
Hi Perry,
We are planning to put in 32 GB RAM with Window Server 2003 Enterprise 32-bits edition.
Yes, I am considering the Window Server 2003 Enterprise 64-bits edition.
The databases...
August 21, 2008 at 4:29 am
CR8NK (8/20/2008)
C:\34 gb 1 disk raid 1 for OSE:\34 gb 1 disk raid 1 for logs
how do you intend to RAID 1 with only 1 disk for each.
you could RAID...
August 21, 2008 at 4:13 am
a sticky plaster rather than a cure. TCP/IP is more secure, check the SPN's i'm sure they'll be the source of your problem. Do the sql services run as a...
August 21, 2008 at 4:11 am
varunsamvedi (8/20/2008)
Exactly, I wonder why the No Recovery option is provided.. :satisfied:Thanks.
so the restore job can successfully restore transaction logs to the database
August 20, 2008 at 9:07 am
multiple instances are ok as long as you pay attention to the instructions Gail has given you
August 20, 2008 at 9:04 am
Viewing 15 posts - 8,941 through 8,955 (of 9,208 total)