Viewing 15 posts - 8,986 through 9,000 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2008 at 9:07 am
multiple instances are ok as long as you pay attention to the instructions Gail has given you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
http://technet.microsoft.com/en-us/library/cc758523.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 11:58 am
update tablename set colname = '00' + colname
Edit:
oops you beat me too it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 10:14 am
gee thanks, i dont need to read BOL now 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 10:07 am
which vendor do you plan on using?
your chosen vendor will supply any training you may need
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 9:59 am
use the following
select @@servername, serverproperty('servername')
they should return the same name, if not use sp_dropserver and then sp_addserver
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 9:53 am
you can generate the SPN's manually using
SETSPN.EXE
syntax is
setspn -A ServiceClass/Host: Port AccountName
so for sql instance is
setspn -A MSSQLSvc/mysqlserver.domain.co.uk:staticsqlportnumber domain\sqlserviceuseraccount
use setspn -L domain\sqlserviceuseraccount
to list the SPN's
😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 9:47 am
Viewing 15 posts - 8,986 through 9,000 (of 9,244 total)