Viewing 15 posts - 5,956 through 5,970 (of 9,253 total)
are the disk\file paths different between the 2 servers?
are you cloning for testing purposes, if so have you thought of cloning the whole server to a virtual machine?
February 25, 2012 at 4:03 pm
saidapurs (2/21/2012)
I got the solution after seeing error log in Witness server.....
Error :-
Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error:...
February 25, 2012 at 9:16 am
hmm, not sure I'd use the index physical stats dmv to get table usages, this should work though
selectobject_name(p.object_id) as TableName
, p.rows
, a.total_pages * 8 as TotalKB
, a.used_pages * 8 as...
February 24, 2012 at 5:16 pm
could you explain why you have set this
SQLRO (2/23/2012)
ROWTERMINATOR = '',
February 23, 2012 at 12:44 am
dbrackin (2/22/2012)
February 23, 2012 at 12:30 am
How many log shipped databases ate we talikng about total?
It sounds like your main aim is to provide availability?
February 23, 2012 at 12:27 am
What share\NTFS permissions are set for Certstore?
February 23, 2012 at 12:17 am
When you launch the sql server installer exactly which option are you selecting?
February 23, 2012 at 12:14 am
Are you trying to use the same group for the new instance on node b that is already in use for the instance on node a
February 23, 2012 at 12:09 am
SQLback (2/22/2012)
It worked. Thanks for the advice.
You're welcome
February 22, 2012 at 8:41 am
Sapen (2/21/2012)
February 22, 2012 at 8:03 am
kumar.sachu08 (2/21/2012)
Hi,I would like to know....Can i use same instance on single server for Primary & Secondary database for Log shipping.
I have only one server and one instance.
Regards,
Sachin.
No you cannot,...
February 21, 2012 at 5:22 am
have you verified connectivity\latency between the instances
February 21, 2012 at 5:20 am
Completely understand, but in my experience pointing out their flawed maint plan and correcting it should serve to gain you a little kudos and maybe even an extension to your...
February 20, 2012 at 11:55 pm
Quite agree, as I said I did not design\deploy the current cluster I work with, if I had I would not have used dedicated heartbeat NICs 😉
February 20, 2012 at 11:50 pm
Viewing 15 posts - 5,956 through 5,970 (of 9,253 total)