Viewing 15 posts - 7,006 through 7,020 (of 9,244 total)
Coolroof (7/4/2011)
windows authendication
I'm assuming you understand the implications of selecting that option?
can you execute the following on the sql server instance and post the results
EXECUTE msdb.dbo.sysmail_help_account_sp
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:58 am
depends on the SAN cache and its config. If it's large enough probably won't make any difference. More importantly check the HBA drivers and config and the LUN config as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:47 am
Coolroof (7/4/2011)
how to check SMPT authendication..?
when you ran the wizard it asked you how you want to authenticate to the SMTP server, what did you select??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:37 am
yes quite right, can see the SP code offering hour minutes or seconds.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:34 am
when adding the SMTP account what authentication did you use?
Windows
Basic
Anonymous
Have you verified the SMTP server address is correct?
What profile security did you select?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:29 am
and don't be tempted to hold the power button for 4 seconds neither, it'll take just as long otherwise when you restart 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:00 am
🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 8:56 am
GilaMonster (7/4/2011)
The DBA exams do cover the DMVs, especially the session-related ones. Hence if you passed that exam you should know these DMVs.
The same thought occurred to me instantly upon...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 8:52 am
winston Smith (7/4/2011)
all instances on my own personal machine.
so, standalone then.
what user account do the sql server services run under?
What ACLs have you applied to the NTFS permissions and the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 8:37 am
winston Smith (7/4/2011)
The restore job runs every 25 seconds.
Hmm, Hours or Minutes are the only frequency options for a job schedule!!!
can you post details of the backup, copy and restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 8:35 am
you're welcome!
I'm not entirely sure it's possible to find how long the restore took, if i find it I'll let you know
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 8:29 am
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 6:32 am
muthukkumaran Kaliyamoorthy (7/4/2011)
DMV will not work against the compatibility 80.
It can and will, see Paul Randall's article at the following link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:37 am
The Backup Exec SQL agent is especially useful for customers who wish to enable backup management within one product and not have to go configuring multiple jobs or plans, etc....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:33 am
System Centre Operations Manager?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:22 am
Viewing 15 posts - 7,006 through 7,020 (of 9,244 total)