Viewing 15 posts - 8,986 through 9,000 (of 9,241 total)
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
set up some perfmon counters and profile the developers code. Once you have the trace and permon results you can tie them together and check for problems that way
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 9:31 am
from BOL 😉
SERVERPROPERTY ( propertyname )
InstanceName
Name of the instance to which the user is connected.
Returns NULL if the instance name is the default instance, if the input is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 9:26 am
bodhilove (8/18/2008)
I am transfering a 2000 db to 2005. I haven't been given a test environment to work with. I am migrating by...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 5:40 am
Viewing 15 posts - 8,986 through 9,000 (of 9,241 total)