Viewing 15 posts - 3,436 through 3,450 (of 9,241 total)
As a dual skilled DBA, i say forget what you know about Oracle. Get the SQL server internals book and give it a good going over multiple times.
I hear...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2014 at 5:52 pm
k.arkenau (3/21/2014)
Ok, there are two intances running on my system, one standard instance (MSSQL) and one named instance (SAPSQL). What to do then?
Under the servername parameter put the full instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2014 at 2:09 am
pheonix623 (3/20/2014)
Select pm.class_desc,
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2014 at 8:54 am
ramyours2003 (3/19/2014)
i need to transfer only the sql logins from one server to another server with the passwords as well, how can we do it ?
Which version sql are you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2014 at 6:24 am
What are you using to ascertain that the login has a grant on the endpoint?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2014 at 5:39 am
you know now 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 5:21 am
do you have a firewall enabled?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 5:17 am
glugingboulder (3/17/2014)
10 node windows cluster
Availability group 1 spans nodes 1 -5.
Availability group 2 spans nodes 5-10.
Essentially you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 5:15 am
zedtec (3/19/2014)
Hi Perry,No confusion.....Failover is performed at the principal server isn't it?
No, not when the principal is dead as you quoted in your scenario above. In this case you would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 5:12 am
k.arkenau (3/19/2014)
Ok, I changed that and added the User to the DCOM User group.Nevertheless, the user still cannot logon to the information services.
Any idea?
If you used distributed com users...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 1:49 am
zedtec (3/18/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2014 at 10:32 am
to add to George, the old principal will become the mirror but the session will be suspended. You will need to manually resume mirroring using
alter database [yourdb] set partner resume
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2014 at 3:49 pm
smtzac (3/15/2014)
Yes. Recovering the Database. I don't think you can switch Principle server to Mirror if Principle is down, can you?
Yes of course you can, but it's a manual failover...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2014 at 10:06 am
New Born DBA (3/14/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2014 at 10:15 am
what do you see if you query the active processes, anything apparent there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2014 at 10:13 am
Viewing 15 posts - 3,436 through 3,450 (of 9,241 total)