Viewing 15 posts - 8,986 through 9,000 (of 9,248 total)
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
Perry Whittle (8/20/2008)
BTW you cant have RAID 1+0 with just 2 disks whatever planet you reside on 😉
with 12GB RAM you'll need 2003 64bit Enterprise
August 20, 2008 at 6:48 am
Edwin (8/19/2008)
I ‘m a newbie on Storage Area Networks. I need to pick it up a lot and I only read some SAN articles on this forum.
We are planning...
August 20, 2008 at 6:45 am
do the sql services start as local system or a user account.
we had this recently on one of our clients, i re registered all the SPN's for the 8 sql...
August 20, 2008 at 6:32 am
Thayal Muhunthan (8/20/2008)
HP Proliant BL480c x5460 4G (2P) - BIG Blade
2 x Quad Core Intel X5460...
August 20, 2008 at 6:28 am
Edwin (8/19/2008)
DellWhat kind of specific training the vendor will provide?
dunno, contact them and find out
Edwin (8/19/2008)
What kind of training should I ask?
how much do you think you need?
what do you...
August 19, 2008 at 11:58 am
update tablename set colname = '00' + colname
Edit:
oops you beat me too it
August 19, 2008 at 10:14 am
Viewing 15 posts - 8,986 through 9,000 (of 9,248 total)