Forum Replies Created

Viewing 15 posts - 3,391 through 3,405 (of 9,244 total)

  • RE: SQL Server on domain or workgroup

    Joining a server to a windows domain provides centralisation of uses and resources.

    Computers in a workgroup require users and objects to be maintained locally on each machine. When providing...

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

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

    April 6, 2014 at 2:33 pm

    #1703599

  • RE: DBCC LOGINFO

    what size did you shrink the file too?

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

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

    April 5, 2014 at 4:51 am

    #1703476

  • RE: AlwaysOn local HA with second site automatic failover.

    PHXHoward (4/3/2014)

    I'm looking for a solution to have cross data center automatic failover in the event of a data center loss for highly critical databases. I would like to have...

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

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

    April 4, 2014 at 5:28 am

    #1703246

  • RE: SQL SERVICE WON'T START

    Talib123 (4/3/2014)

    The file it was looking for was MODEL.log. WHen in fact the file was still Modellog.ldf.

    Yes, so if you follow my steps above you'll recover with no issues

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

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

    April 3, 2014 at 6:56 am

    #1702835

  • RE: SQL SERVICE WON'T START

    Talib123 (4/3/2014)

    Thanks Gail, was hoping you would reply. I'll have a crack with your advise later. Only my sandpit environment so BAU comes first. If I ever get the time...

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

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

    April 3, 2014 at 6:06 am

    #1702815

  • RE: installing Sql 2012 Evaluation version on Windows 7 Pro

    ok, didnt spot that

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

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

    April 2, 2014 at 7:10 am

    #1702447

  • RE: Script out passwords

    lol convert this

    0x646F6E2774206265206120646F726B20203A2D29

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

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

    April 2, 2014 at 6:01 am

    #1702403

  • RE: SQL SERVICE WON'T START

    Talib123 (4/2/2014)

    While trying to move the MSDB and Model DB, I mistakenly ran the following

    ALTER DATABASE model

    MODIFY FILE (NAME = modelData, FILENAME = 'D:\New folder\model.mdf')

    GO

    ALTER DATABASE model

    MODIFY FILE (NAME =...

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

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

    April 2, 2014 at 4:27 am

    #1702385

  • RE: installing Sql 2012 Evaluation version on Windows 7 Pro

    The software requirements list Windows 2012 or Windows 2008 only for Enterprise edition, see this link

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

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

    April 2, 2014 at 3:08 am

    #1702359

  • RE: Question about SQL2012 availability groups & security

    And as part of your AO group deployment you've already identified a preferred Primary 😉

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

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

    April 2, 2014 at 1:07 am

    #1702342

  • RE: Question about SQL2012 availability groups & security

    Zubius (4/1/2014)

    How should application/users security be set up? If server #1 fails, availability group #1 fails over to server #2 but the security does not, so applications...

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

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

    April 1, 2014 at 1:43 pm

    #1702208

  • RE: SQL Cluster

    Enthusiastic Jones (4/1/2014)

    I'm referring to the option in cluster manager where if the agent can't start it causes the instance to failover to another node. I'm trying to see how...

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

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

    April 1, 2014 at 1:18 pm

    #1702202

  • RE: SQL Cluster

    Enthusiastic Jones (4/1/2014)

    Should it be setup so that an instance be set to failover if the SQL Server Agent fails?

    Thoughts??

    The default for this resource is the same as others, initially...

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

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

    April 1, 2014 at 9:38 am

    #1702108

  • RE: IDENTITY(1,1) doesn't work, from 17 jumped to 1001

    mario17 (3/31/2014)

    Thanks, all

    Yes, I did reseed and it worked.

    DBCC CHECKIDENT ('Person.AddressType', RESEED, 10);

    The problem here is, when the value jumped if identities were created in the upper range and you...

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

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

    April 1, 2014 at 3:47 am

    #1701929

  • RE: IDENTITY(1,1) doesn't work, from 17 jumped to 1001

    TheSQLGuru (3/31/2014)

    If you shut down SQL Server there is a known bug that advances the identity values. I don't know if there is a fix for that or not.

    according...

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

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

    April 1, 2014 at 3:45 am

    #1701926

Viewing 15 posts - 3,391 through 3,405 (of 9,244 total)