Viewing 15 posts - 5,671 through 5,685 (of 9,253 total)
jonathanalvestad (4/18/2012)
I'm in a student group working on a project, our project needs a website with possibilities to make orders...so...
April 18, 2012 at 10:41 am
if you go into the new help dialog and click updates you will be presented with a list of help topics to download including BOL
April 18, 2012 at 9:51 am
karthik.catchme (4/16/2012)
What is the difference between Availability Group and Replica? I understand that availability group is a container for set of databases.
But, can someone please let me know...
April 18, 2012 at 9:49 am
if you don't have a shared volume it won't use one but will warn that the current configuration is not suitable for the number of nodes
April 18, 2012 at 9:40 am
you need to restore the full backup using either
WITH NORECOVERY
or
WITH STANDBY = drive:\path\standby_file_name
you may then initiate log shipping. Alternatively let the Log Shippiong setup process do this for you...
April 18, 2012 at 6:44 am
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...
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...
April 18, 2012 at 6:33 am
have you checked the Windows application and system logs?
April 18, 2012 at 5:56 am
view the catalog sys.mesages, that should give you some idea
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...
April 18, 2012 at 5:52 am
jayan_unni (4/17/2012)
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...
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,...
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....
April 17, 2012 at 7:02 am
Viewing 15 posts - 5,671 through 5,685 (of 9,253 total)