Viewing 15 posts - 5,671 through 5,685 (of 9,244 total)
sc_2111 (4/18/2012)
if I take down the MIRRORED DATABASE on the principal the target should become active automatically.
Loss of the Principal will indeed bring the mirror online, again, check Automatic Failover...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 6:39 am
dsohal (4/18/2012)
I restored for .bak file and then ran the query to make the database as read only, I am not sure how to make it standby/read
so, you restored the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 6:33 am
have you checked the Windows application and system logs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 5:56 am
view the catalog sys.mesages, that should give you some idea
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 5:54 am
APA0876 (4/17/2012)
What will be the first step on this setup:Create Windows Cluster or Map the Drives first?
You can do it either way. If you pre create all your LUNs and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 5:52 am
jayan_unni (4/17/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 5:41 am
dsohal (4/17/2012)
I have the log shipping data on secondary server as READ, How can I make it as READ/STANDBY Only
Not sure what you mean here, the only options you have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2012 at 5:40 am
winston Smith (4/17/2012)
When you enable kerberos, you dont need to restart the service, kerberos simply takes over.
but to disable kerberos,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2012 at 11:02 am
Junior DBA.M (4/17/2012)
We have two servers on a work group. The second server does not have SQL server on it, it is just a disk....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2012 at 7:02 am
charipg (4/17/2012)
Then we reinstalled C++ libraries , 2005 SP1 version....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2012 at 6:58 am
balasach82 (4/17/2012)
😀 Perry,you are right. its 1024Mb, not 1000mb
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2012 at 6:57 am
When configured correctly it works well. Can you supply more detail on the set up you have, mutli path, etc?
For an idea of getting things setup see my popular guide...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2012 at 6:56 am
Junior DBA.M (4/17/2012)
I would like to set up a daily job that backs up the database and transfers a copy of the backup on to a disk on a different...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2012 at 4:33 am
opc.three (4/16/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2012 at 4:56 pm
winston Smith (4/16/2012)
Just remoted in and gave this a try and it worked! I spent 3 hours looking at this before leaving it for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2012 at 4:26 pm
Viewing 15 posts - 5,671 through 5,685 (of 9,244 total)