Forum Replies Created

Viewing 15 posts - 3,211 through 3,225 (of 9,244 total)

  • RE: FULL --> SIMPLE --> FULL Recovery Model - SQL 2008 R2 Standard

    lilywhites (6/25/2014)

    There is a 56GB table with a PK that needs to be rebuilt/dropped-created

    I'm assuming you're referring to rebuilding the clustered index that was created on the PK column?

    You don't...

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

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

    June 26, 2014 at 9:03 am

    #1725140

  • RE: Best way to copy a database to another instance daily

    UconnDBA (6/26/2014)

    As far as overlay users I mean that the source and target will have different users/permissions. If we do a backup/restore the users at the target will now...

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

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

    June 26, 2014 at 7:37 am

    #1725073

  • RE: Best way to copy a database to another instance daily

    UconnDBA (6/26/2014)

    Looking for what others have done to keep a copy of a database, for read only, on another instance. Need to do this once a day early in...

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

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

    June 26, 2014 at 7:02 am

    #1725049

  • RE: Cluster Errors - No Auto Fail over??

    GBeezy (6/25/2014)

    I am somewhat of a beginner when it comes to clustering. I am learning on the job and looking into good training to speed up this process. ...

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

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

    June 26, 2014 at 4:48 am

    #1725006

  • RE: best practice for remote connecing to SQL Server Express?

    Eric Mamet (6/26/2014)

    Perry,

    This fixed the problem on my test machine.

    I did not have to create an outbound rule on the client windows firewall, though.

    However, there are so many rules...

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

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

    June 26, 2014 at 4:34 am

    #1725003

  • RE: Database Mirroring - Disconnected between Mirror and Witness

    tommi_j (6/26/2014)

    I guess removing the mirroring and then configuring the same setup again could work but this is a critical DB and not easily done.

    What's so difficult about it?

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

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

    June 26, 2014 at 4:31 am

    #1724999

  • RE: Upgrading from SQL Server 2008 Enterprise standalone to SQL 2012 cluster

    faisalfarouqi (6/26/2014)

    Thanks! Perry....but then you're asking me again to migrate the objects which isn't what I want to do. Basically, all I want to do is an in-place upgrade.

    Regards,

    Faisal

    There is...

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

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

    June 26, 2014 at 4:27 am

    #1724996

  • RE: SQL Server clustering - hardware

    Also be careful if using cpu affinity in the sql instance . If you apply affinity on the 80 core system and it tries to failover to less cores the...

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

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

    June 25, 2014 at 2:04 pm

    #1724807

  • RE: Upgrading from SQL Server 2008 Enterprise standalone to SQL 2012 cluster

    faisalfarouqi (6/25/2014)

    Yes...that is absolutely correct. Do you think by any chance this is a possible solution.

    Regards,

    Faisal

    No, it's not even remotely possible!!

    Here's what you could do (and incidentally what i would...

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

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

    June 25, 2014 at 2:00 pm

    #1724803

  • RE: Proper Shutdown of SQL Servers in a Cluster

    PhilipC (6/18/2014)

    I was just wondering what the best approach should be for shutting down an Active/Active Cluster where both nodes need to be shutdown for disk maintenance.

    I was thinking of...

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

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

    June 25, 2014 at 8:53 am

    #1724669

  • RE: Upgrading from SQL Server 2008 Enterprise standalone to SQL 2012 cluster

    faisalfarouqi (6/24/2014)

    Hi all,

    I am in need of upgrading my current SQL instance (servera\inst1) running on 2008 enterprise edition stand-alone to sql 2012 clustered. Could someone pls. provide some guidelines as...

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

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

    June 25, 2014 at 8:13 am

    #1724646

  • RE: How to select the last characters from a string?

    Sniffer2010 (6/19/2014)

    I have the following string and am trying to select only the characters before the last "</>". How can I do this?

    declare @String varchar(500)

    set @String = '<p>Assessed By:...

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

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

    June 25, 2014 at 8:05 am

    #1724642

  • RE: SQL Server clustering - hardware

    cheshirefox (6/23/2014)

    Hi -

    I have two servers, one with 80 cores and another with 64 cores. Both are HP 980's. Different chip set and both connected to a flash appliance.

    My question...

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

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

    June 25, 2014 at 7:54 am

    #1724637

  • RE: NT Service \ MSSQL$Instance Name

    river1 (6/25/2014)

    Hi,

    I have installed the SQL Server 2012.

    When I try to start the service it says that the credentials are not good.

    SQL Server 2012 puts my SQL Server Service with...

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

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

    June 25, 2014 at 7:49 am

    #1724633

  • RE: Copy whole instance to different server.

    Rudyx - the Doctor (6/24/2014)

    hmmm ... moving system databases to another server ...

    hmmm ... should not be attempted ???

    I would call that Disaster Recovery !

    any decent DBA should be able...

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

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

    June 24, 2014 at 5:23 pm

    #1724494

Viewing 15 posts - 3,211 through 3,225 (of 9,244 total)