Viewing 15 posts - 4,096 through 4,110 (of 7,499 total)
- your sqlagent has not been started (cluster manager)
(do you use SQLAgent ?)
- you can enable these procs this way:
-- enable Agent XPs
EXEC sp_configure 'Agent XPs','1'
RECONFIGURE
GO
This way you can...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 25, 2009 at 11:51 pm
cluttering is another branche 😉
Steve showed you some good refs for SQLServer clustering.
Another good ref is the SQL Server 2005 Failover Clustering White Paper http://www.microsoft.com/downloads/details.aspx?familyid=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en
It always pays of to have...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 25, 2009 at 10:39 am
Mad-Dog (1/25/2009)
has anyone that have sp3 install and setup this alert in the SQL alert doesn't suffer from...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 25, 2009 at 10:34 am
Jeff Moden (1/25/2009)
Thanks for the links, Johan... I'll take a look (am I spelling your name correctly?)
Yep, Johan is correct.:w00t:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 25, 2009 at 9:30 am
I first installed it on a couple of non clustered instances.
I don't perform unattended installs .... must be my age 😉
Basic scenario on our cluster:
- move over all instances to...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 25, 2009 at 4:22 am
Jeff Moden (1/24/2009)
... if they fit, that's as far as they go. If they don't, then they spill into the physical disk.
"If" is the unknown over here,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 25, 2009 at 3:45 am
It was a x64 cluster (2 nodes / 5 instances) all updated in a single run (because of the approved downtime). The actual upgrade took about a bit less than...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 25, 2009 at 3:36 am
since you're at it ... this is what I experienced with logon triggers : http://www.sqlservercentral.com/articles/Administration/64974/
With regards to the login info:
Select name
, create_date
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 24, 2009 at 9:01 am
also keep in mind temp tables (@ / # / ## ) are hosted in tempdb. tempdb is used at (sqlserver) instance level, for more than only storing temp tables....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 24, 2009 at 8:57 am
I didn't encounter any issues applying SP3. (x86 / x64)
The 5 servers were we were on SP2 CU10 I have also upgraded to SP3 + CU1 without an issue.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 24, 2009 at 7:18 am
TheSQLGuru (1/22/2009)
Joe Celko (1/22/2009)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 23, 2009 at 12:05 am
Norm (1/22/2009)
....question: Would xp_cmdshell still have to be enabled if I run it as a operating system (cmdexec) type in my sql server job?
No, you can disable xp_cmdshell, SQLAgent has...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 22, 2009 at 12:45 pm
- Did your stop trace work ?
- Since you are using "EXEC xp_cmdshell 'd:\mssql\scripts\audit\rename_ddltrace.bat', NO_OUTPUT"
Why don't you just provide the rename statement itself ?
Dim @Doscmd nvarchar(max)
Set @Doscmd = 'ren D:\MSSQL\reports\audit\audit_ddl.trc...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 22, 2009 at 7:35 am
IMO just copying SMO.dll will not do the trick you want.
Keep in mind you can connect to non-local servers/instances as well, so you should be able to perform your actions...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 22, 2009 at 7:26 am
Does your "3. run a dos batch file to rename the trace file with a timestamp" succeed when the start new trace fails ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 22, 2009 at 12:58 am
Viewing 15 posts - 4,096 through 4,110 (of 7,499 total)