Forum Replies Created

Viewing 15 posts - 181 through 195 (of 442 total)

  • RE: How to find cause of failover in clustering?

    Perry Whittle (9/17/2013)

    Open fail over cluster manager and view cluster events there

    When I open the cluster Events it's blank....it says " no query is defined.

    September 17, 2013 at 11:01 am

    #1650864

  • RE: How to find cause of failover in clustering?

    Perry Whittle (9/17/2013)

    refer to the cluster events console and the app and sys event logs for more info

    cluster events console, can you tell me how can I access this event...

    September 17, 2013 at 8:03 am

    #1650799

  • RE: Mirroring and big transaction log file

    kalczynski (9/16/2013)

    Hi All

    I have mirrored database with 2 Databases Motor and one witness. Size of one Database is 467 Mb, but transaction log is 64 GB. Model of backup -...

    September 16, 2013 at 6:31 pm

    #1650657

  • RE: Principal server unexpected shutdown?

    GilaMonster (9/7/2013)

    SQLisAwE5OmE (9/7/2013)

    However, if your mirror is in high performance mode and if principal goes down, then definitely there will be some data loss.

    Not definitely. There may be some data...

    September 7, 2013 at 2:47 pm

    #1648349

  • RE: Principal server unexpected shutdown?

    ananda.murugesan (9/7/2013)

    Ok.. understand.. Thanks for reply

    1. High performance mode - there is some data loss due to ackownledgement not received to Principal server from secondary server ..( so how to...

    September 7, 2013 at 9:20 am

    #1648336

  • RE: [CLUSTER] Multiple Instances Design

    dokledon (8/24/2013)

    Hi,

    I want my Applications to connect to SQL cluster Instances only using VIP SQL Name (SQL Virtual Network Name).

    I thought about this design:

    1) SQL1\Default

    2) SQL2\Default

    3) SQL3\Default...

    August 25, 2013 at 7:16 am

    #1644711

  • RE: DR Testing Question

    SQLSteve (8/15/2013)

    That depends on your app and how it connects to the database? You should set up a DNS for it, then in a DR scenario you just need to...

    August 15, 2013 at 11:21 am

    #1641879

  • RE: Script to reset password for SQL 2000

    GilaMonster (8/14/2013)

    That's 2005+ syntax.

    Look up sp_password for SQL 2000 and older.

    Thanks Gail.

    August 14, 2013 at 4:29 pm

    #1641614

  • RE: Permissions for add users to one database only

    wjlugaila (8/12/2013)

    Is there a way that I can set a SQL account to be able to add new users to only a certain database and no other databases?

    If I understand...

    August 12, 2013 at 3:56 pm

    #1640722

  • RE: DR Testing Question

    Andrew G (7/3/2013)

    You don't need to fail-over at all, just break mirroring, then RESTORE WITH RECOVERY on the mirror to make it useable. Then recreate the mirror after the...

    August 1, 2013 at 3:14 pm

    #1637977

  • RE: Question about user and login

    bonifacy (7/29/2013)

    Hello

    I created new login and new user to exists login. Next step is log to database with created username database and login password??

    Regards

    I don't really understand your question here?...

    July 29, 2013 at 8:16 pm

    #1636810

  • RE: Cluster backup drives

    jpettigrew (7/25/2013)

    I cannot see the main backup drive in SQL cluster when attempting to do a restore. The backups for the cluster is stored on this drive. I only see...

    July 28, 2013 at 11:48 am

    #1636477

  • RE: sys.dm_db_index_physical_stats - Doubt in the Results

    GilaMonster (7/18/2013)

    Well index rebuilds are unlikely to make noticable improvements in performance, so maybe the question should rather be 'what can be done'

    Tune the query to use indexes, modify/add indexes...

    July 18, 2013 at 9:57 am

    #1633703

  • RE: SQL Netbackup Job failures

    HanShi (7/17/2013)

    Can you post the error message from the logging/job history?

    Hi Hanshi, Here is some backup failure error I found....I have modified the error slightly to avoid the servername, dbname,...

    July 18, 2013 at 9:11 am

    #1633677

  • RE: latch

    GilaMonster (7/16/2013)

    SQLisAwE5OmE (7/16/2013)

    Latch = is a type of lock you place in buffer cache

    No.

    locks = are placed against resources.

    No.

    Maybe take a read through the search links I posted above.

    Okay, Thanks...

    July 16, 2013 at 2:53 pm

    #1633012

Viewing 15 posts - 181 through 195 (of 442 total)