Forum Replies Created

Viewing 15 posts - 376 through 390 (of 442 total)

  • RE: Assist in rebooting the server

    anthony.green (7/18/2012)

    Personally I would follow these steps.

    Pause the passive node in the cluster

    Perform the netbackup upgrade on the passive node

    Test make sure it works

    Uninstall/Reboot depending on above

    Unpause the passive node

    Fail...

    Regards,
    SQLisAwe5oMe.

    July 18, 2012 at 6:14 am

    #1514157

  • RE: Assist in rebooting the server

    Let me just re-phrase the question or clarify.....I know how to restart SQL in cluster...this is what I know....Cluster Administrator, select SQL Server resource, then take offline, followed by bring...

    Regards,
    SQLisAwe5oMe.

    July 17, 2012 at 7:08 pm

    #1513971

  • RE: Where does Login Name in New Login Window come from

    schleep (7/12/2012)

    I click on Security, Logins, New Login, Windows, Search. Find the username in the directory listing. Click on it. It is in FirstName.LastName@domain.com format.

    Click OK. The Login name field...

    Regards,
    SQLisAwe5oMe.

    July 12, 2012 at 10:55 am

    #1512192

  • RE: Differential backups rendered useless by backup device

    sqlskj4000 (7/10/2012)

    gotcha. i'll find out from the network guys if the backup device properties can be adjusted to not talk to sql.

    Thanks!

    Please keep us posted with your findings. This...

    Regards,
    SQLisAwe5oMe.

    July 10, 2012 at 8:18 pm

    #1511307

  • RE: Memory Management Details

    GilaMonster (6/15/2012)

    SQLCrazyCertified (6/14/2012)

    Please correct me if I have mentioned anything incorrectly.

    Why do you specifically call out AWE on 32 bit SQL on 64 bit OS, but make no mention of...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 5:08 pm

    #1501919

  • RE: Users with differenct access permissions on application and on dataase

    SQLCrazyCertified (6/15/2012)

    DBA_SQL (6/15/2012)

    Does anyone know how to set a user an application role? I am still in process of assigning a single user with different level of access, as one...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 2:37 pm

    #1501893

  • RE: Users with differenct access permissions on application and on dataase

    DBA_SQL (6/15/2012)

    Does anyone know how to set a user an application role? I am still in process of assigning a single user with different level of access, as one if...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 2:13 pm

    #1501884

  • RE: SQL 2008 R2 Cluster (Active/Active)

    kylemkr85 (6/15/2012)

    Alright, thank you for the input and suggestions. We have about 10 including our testing environments currently which we will be migrating.

    You are welcome.....we are all here to learn.

    TA.

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 12:58 pm

    #1501854

  • RE: SQL 2008 R2 Cluster (Active/Active)

    kylemkr85 (6/15/2012)

    This system was in place years ago. I just started here about 2 weeks ago and they are looking to move everything to a cluster environment now along with...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 12:41 pm

    #1501847

  • RE: SQL 2008 R2 Cluster (Active/Active)

    kylemkr85 (6/15/2012)

    We have 7 windows server and 1 SQL server installed in each of the windows server. Each SQL server has about 10 - 15 databases.

    Wow....was that the requirement from...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 12:21 pm

    #1501838

  • RE: SQL 2008 R2 Cluster (Active/Active)

    kylemkr85 (6/15/2012)

    Sorry I didnt mean we have 7 instances right now. I just meant we have 7 standalone servers with about 10 - 15 databases on each one. So a...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 11:58 am

    #1501832

  • RE: SQL 2008 R2 Cluster (Active/Active)

    kylemkr85 (6/15/2012)

    No, we are moving from non-cluster SQL 2005 environment to a clustered SQL 2008 R2 environment. We have already moved 2 instances over to it, but are questioning if...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 11:43 am

    #1501826

  • RE: SQL 2008 R2 Cluster (Active/Active)

    kylemkr85 (6/15/2012)

    Ill take that into consideration. We have about 7 independent SQL servers right now with about 8 to 15 databases on each one. Would our current cluster environment be...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 11:27 am

    #1501823

  • RE: SQL 2008 R2 Cluster (Active/Active)

    kylemkr85 (6/15/2012)

    Hello,

    I have a question regarding an ACTIVE/ACTIVE Cluster enviornment using SQL Server 2008 R2. We have several instances of SQL which we currently need to migrate from SQL 2005...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 11:22 am

    #1501821

  • RE: UAT server refresh strategy

    Jason Marshall (6/15/2012)

    Sure; I mean updating the schema and data of our "warehouse" databases, for lack of a better term. These are databases that hold current and historical data...

    Regards,
    SQLisAwe5oMe.

    June 15, 2012 at 11:00 am

    #1501801

Viewing 15 posts - 376 through 390 (of 442 total)