Forum Replies Created

Viewing 15 posts - 6,256 through 6,270 (of 9,244 total)

  • RE: Setup SQLServer 2008 DR database using NetApp?

    No snapmanager, use SQL server log shipping.

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Fix orphaned users after restoring database to another server.

    Vladimir Mednikov-324895 (11/15/2011)


    You can script missing logins and user roles on the source server and recreate them on the target server before fixing orphan users.

    Database roles are transferred with the...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Active to Active Load balancing Cluster set up & hardwares

    chandan_kumar_sahu-987370 (11/8/2011)


    Hi

    I am a database developer and expected to a DBA activity for High availability concept.

    We have a requirement to set up windows2008 R2 server Cluster environment with SQL...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Fix orphaned users after restoring database to another server.

    Vladimir

    I have not had chance to verify the code yet but the following is bothering me.

    The temp table is populated by database users who have SUSER_NAME(SID) is null, this...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: windows cluster not responding. SQL Services down

    Reboot is a little drastic but if that works for you.

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Newbie to SQL Clustering..please help

    Dev (11/14/2011)


    After all the articles and conversations on this topic and you still have this oh so wrong.

    What’s your point? What's wrong in the articles?

    The point my friend...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Newbie to SQL Clustering..please help

    After all the articles and conversations on this topic and you still have this oh so wrong. MysteryJimbo has covered a lot of the key points. I would suggest you...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: windows cluster not responding. SQL Services down

    dba_mb (11/13/2011)


    we have a Win 2008 cluster active/active. users called in for connection issues. The windows cluster group is not pinging. I opened failover manager and couldn't find anything listed...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: trace

    Dude

    This post is well over a year old πŸ˜‰

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Using and Creating Mount Points in SQL Server

    SAinCA (11/10/2011)


    I'll be sure to make mine around 250GB to 500GB for the tables and partitions I have to deal with.

    Cheers. Appreciate the detail you went to in the...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Using and Creating Mount Points in SQL Server

    k-335975 (11/10/2011)


    Perry,

    I usually monitor Avg. Disk sec/Read and Avg. Disk sec/Write to check disk activity, without mount points adding this counters in perfmon is not an issue. But with mount...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Using and Creating Mount Points in SQL Server

    SAinCA (11/10/2011)


    The dialog boxes showed a max disk size of a smidge over 7GB. Where does that come from? Is it a limitation? What...? (As in,...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Using and Creating Mount Points in SQL Server

    rmechaber (11/10/2011)


    For containing SQL system files, they seem like just another way to create a virtual disk/shortcut to space on an NTFS volume.[/Quote]

    They may be used for system files, database...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Database mirroring error

    philip.nash (11/8/2011)


    Hi Perry,

    Thanks, for the information. I deleted and then recreated end points, login etc used the new login and associated it with new endpoints and it all worked successfully.

    Once...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

    Peter Jin (11/7/2011)


    Hi Perry,

    Is it possible to run the exercise on VMWare ESXi 4.0?

    The process differs a little, but yes it is completely possible. I run mine on ESX πŸ˜‰

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

Viewing 15 posts - 6,256 through 6,270 (of 9,244 total)