Forum Replies Created

Viewing 15 posts - 4,231 through 4,245 (of 9,244 total)

  • RE: Combining AlwaysOn Groups With Failover Cluster Instances

    Marios Philippopoulos (3/26/2013)


    Thank you for the article.

    You're welcome.

    Marios Philippopoulos (3/26/2013)


    We are building a 3-node WSFC cluster that includes a 2-node FCI (active-passive configuration) coupled with a standalone AlwaysOn-AG instance on...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL 2012 Cluster Multiple Instances Procedure !

    Asim 6451 (3/26/2013)


    Hello,

    Kindly help me if I need different sources for each instance or can I use the same for all the instances I want to install like, SAN Driver,...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: LDF is IDF instead

    Just about all AV programs can be customised. If you did have a file with .idf extension just add it to the exclusion list

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Combining AlwaysOn Groups With Failover Cluster Instances

    Marios Philippopoulos (3/26/2013)


    I was reading an article that described a similar scenario of a single WSFC comprised of 2 FCIs

    Could you provide the article link please

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Cluster setup--system databases

    muthyala_51 (3/22/2013)


    Jay,

    We tested it on the dev servers and we never had any issue with shared drives. We never restarted the service. I am not sure why you wanted to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Cluster setup--system databases

    Jay Beta (3/22/2013)


    Actually from what I understand not all shared disks are dependencies for the SQL Server resource. The Quorum and DTC LUNS will not be able to be added...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Backup databases depending on the size to multiple files

    This

    BACKUP DATABASE Test1

    TO DISK = 'C:\temp\20130319_1.bak',

    TO DISK = 'C:\temp\20130319_2.bak',

    TO DISK = 'C:\temp\20130319_3.bak',

    TO DISK = 'C:\temp\20130319_4.bak',

    TO DISK = 'C:\temp\20130319_5.bak'

    Should be this

    BACKUP DATABASE Test1

    TO DISK = 'C:\temp\20130319_1.bak',

    DISK = 'C:\temp\20130319_2.bak',

    DISK =...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Sql Server 2008 r2 active/active configuration

    Creating a clustered DTC service to run on each node wont harm anything, do you have a lot of DTC activity in the cluster?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Cluster setup--system databases

    all the shared disks are dependencies otherwise how would the service start

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: how to create user that can login to create and edit but cannot delete?

    GilaMonster (3/17/2013)


    Or, instead of using the roles, you could GRANT SELECT, INSERT, UPDATE on the database instead.

    Make sure that the login is not sysadmin, the user is not db_owner and...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: how to create user that can login to create and edit but cannot delete?

    after granting the roles you would need to DENY delete not REVOKE

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: what is certificate and its usage

    What is it you are not clear on?

    Do you understand the concept of public and private keys?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: smk and dmk in sql 2008

    You cant view them, to understand what they are check books online for more info.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: how to create user that can login to create and edit but cannot delete?

    clintonG (3/16/2013)


    Here is one solution perhaps the best I've learned so far:

    // Transact-SQL

    REVOKE privilege_name

    ON object_name

    FROM {user_name |PUBLIC |role_name}

    // Example

    REVOKE DELETE

    ON TransactionRecordsTable

    FROM employee

    REVOKE only clears the granted permission,...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: how to create user that can login to create and edit but cannot delete?

    clintonG (3/14/2013)


    Circumstances require a user that can be restricted to login to a specific database to create and edit data entered into tables but cannot delete anything. I presume this...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 4,231 through 4,245 (of 9,244 total)