Forum Replies Created

Viewing 15 posts - 34,396 through 34,410 (of 49,552 total)

  • RE: Instance will not start

    There's a space missing on the first of those parameters

    -dF:\MSSQL\OVOPS\Datafiles\master.mdf

    should be

    -d F:\MSSQL\OVOPS\Datafiles\master.mdf

    Fix that and see if that lets SQL start or at least changes the errors.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 12:55 pm

    #1108895

  • RE: Instance will not start

    Sopheap Suy (1/26/2010)

    It is advised that you should not move master or mssqlsystemresource. It is possible to move it in 2005, but not 2008.

    It's possible to move master, providing...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 11:48 am

    #1108860

  • RE: Instance will not start

    Ok, it's not model or msdb that you messed up, it's master.

    Is the master data file in this directory? F:\MSSQL\OVOPS\Datafiles\master.mdf

    Is the master log file in this directory? G:\MSSQL\OVOPS\Logfiles\mastlog.ldf

    If not, move...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 11:43 am

    #1108859

  • RE: Instance will not start

    What does the SQL error log say? It's a textfile, will have the name ERRORLOG.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 11:01 am

    #1108830

  • RE: Help! Connection to server seems to be dead!

    harpistic (1/26/2010)

    Gail - I was oversimplifying there about Suspect status - I was Googling it yesterday morning, and that seems to be the reason the database went down - but...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 10:58 am

    #1108828

  • RE: Help! Connection to server seems to be dead!

    harpistic (1/26/2010)

    Moth - SQL Server will flag databases as "Suspect" and taken offline if there are data errors - there were a bunch of data integrity errors in the server...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 10:10 am

    #1108798

  • RE: Are the posted questions getting worse?

    "I've never heard of that term. Here are some suggestions anyway"

    http://www.sqlservercentral.com/Forums/FindPost853704.aspx

    This time it's not the question that's bad....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 9:33 am

    #1108771

  • RE: Insert Data Multiple Times

    To even begin to get you a working solution, I'd also need to see the definition of the source table and some sample data in it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 9:32 am

    #1108770

  • RE: Help! Connection to server seems to be dead!

    MothInTheMachine (1/26/2010)

    Thanks Gila...I had never heard of that term 'suspect' so I was shooting in the dark.

    Forgive me for being blunt, but why are you offering advice and suggestions...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 9:26 am

    #1108766

  • RE: Insert Data Multiple Times

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 8:13 am

    #1108710

  • RE: Help! Connection to server seems to be dead!

    MothInTheMachine (1/26/2010)

    If the intial reason for your db being suspect was due to running out of space your running dbcc on it wouldn't help matters as I believe that increases...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 7:46 am

    #1108686

  • RE: Small mdf file, large ndf file

    jvElecenter (1/26/2010)

    Does this lead to performance issues ?

    Not by itself, no.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 7:44 am

    #1108684

  • RE: Help! Connection to server seems to be dead!

    A general network error is just a general can't connect error. Most likey cause is that the SQL Service is not running. You need to get remote access to the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 7:42 am

    #1108682

  • RE: delete all Tlog backups following a successful full DB backup

    Are you sure that you want to do that? What happens if, when going to restore, you find that the latest full DB backup is corrupt? Or find out that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 7:40 am

    #1108680

  • RE: We'll go no more a' tibbling

    Grant Fritchey (1/26/2010)

    Only the unique constraint on the index would be of use when looking at the execution plan.

    And whether or not it's filtered

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 26, 2010 at 7:30 am

    #1108662

Viewing 15 posts - 34,396 through 34,410 (of 49,552 total)