Forum Replies Created

Viewing 15 posts - 3,856 through 3,870 (of 9,241 total)

  • RE: after removing last node from cluster - uninstall from node??

    inevercheckthis2002 (12/5/2013)

    I am uninstalling and reinstalling SQL Server 2008 R2 on a cluster. Instructions on how to uninstall from a cluster have you remove all the nodes.

    After doing so,...

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

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

    December 5, 2013 at 8:38 am

    #1671150

  • RE: SQL Orphan login issue

    Aatish Patel (12/5/2013)

    I copied database from Prod to Dev instance. Whe the database was restored I ran

    -----See if there are any orphan users:

    EXEC sp_change_users_login 'Report'

    The output was :

    finq_sql...

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

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

    December 5, 2013 at 8:31 am

    #1671144

  • RE: SqlServer 2008 cluster adding RAW disks VMWARE

    Gerard Silveira (11/7/2013)

    Thanks for the reply

    When you say easier to store with the VM, do you mean the same LUN that the .vmdk file is stored on

    OR

    Do...

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

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

    December 5, 2013 at 3:50 am

    #1670980

  • RE: Moving TempDB of the Cluster Resource

    Leo.Miller (2/14/2011)

    David Benoit (2/14/2011)

    They had a nice shiny new SAN installed to improve performance,

    Storage Area Networks are implemented for consolidation not performance, much like virtualisation is implemented for consolidation....

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

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

    December 5, 2013 at 3:45 am

    #1670979

  • RE: TRANSACTION LOG COPY JOB FAILED IN LOGSHIPPING

    cpathidba (12/5/2013)

    Hi Praveen,

    I had given those permissions also,still it was showing same error, please help us.

    thanks & regards

    Chalapathi

    It is the SQL...

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

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

    December 5, 2013 at 3:37 am

    #1670975

  • RE: Restore Syntax

    So these are native backups from 2005 rtm?

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

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

    November 29, 2013 at 10:21 am

    #1669857

  • RE: Restore Syntax

    which version\edition of sql server are you using?

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

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

    November 29, 2013 at 8:22 am

    #1669843

  • RE: Restore Syntax

    Welsh Corgi (11/27/2013)

    I atttached the word work with screen shot and tried to open myself but I could not open it?

    How can I embed an image intop my post?

    Thanks.

    I opened...

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

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

    November 29, 2013 at 7:08 am

    #1669833

  • RE: I am not able to connect to sql server database engine from my machine to server having different networks.

    AShehzad (11/25/2013)

    If you can ping the server from your machine then probably it will not be a firewall issue.

    Correct, ICMP traffic is the first traffic a firewall usually blocks. If...

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

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

    November 29, 2013 at 7:00 am

    #1669830

  • RE: How to split filegroup files to more than physical storage drive

    MohamedDBA (11/24/2013)

    Are I can spread my database filegroup files to more than storage drive , not on the same storage drive , and stay connected logically as if they in...

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

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

    November 29, 2013 at 6:56 am

    #1669828

  • RE: Using VMs in a cluster

    NJDave (11/27/2013)

    Hello

    Could someone provide insight on using 2 VMs in a cluster fro SQL Server 2008 R2 (or higher)?

    Today, I have 2 physical boxes in an active passive cluster that...

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

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

    November 29, 2013 at 6:32 am

    #1669823

  • RE: Domain Migration - Log Shipping and Mirroring

    pradeep.mohan (11/26/2013)

    Hi,

    Will it affect domain changes in log shipping and mirroring???

    Because currently SQL server services running on xxxx\xxxxx domain account and log shipping and mirroring working properly. We are planning...

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

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

    November 29, 2013 at 6:16 am

    #1669820

  • RE: Need to use Kerberos, but it still is using NTLM

    Marcia Q (3/2/2011)

    I am having trouble with my SQL server not using Kerberos. I read Brian Kelly's article on sqlservercentral.com, but I STILL have problems...

    Here's our setup:

    SQL...

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

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

    November 20, 2013 at 9:21 am

    #1667848

  • RE: Sql connection with port number

    sqlmunkee (11/19/2013)

    Do you really need the instance name and the port number ?

    No, you dont.

    use either

    server\instancename

    server, portnumber

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

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

    November 19, 2013 at 5:21 am

    #1667360

  • RE: Server side trace question

    sunny.tjk (11/18/2013)

    The steps of the job are

    (1)start trace

    (2)run the trace for 2 mins

    (3)stop trace

    ??

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

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

    November 19, 2013 at 1:10 am

    #1667314

Viewing 15 posts - 3,856 through 3,870 (of 9,241 total)