Forum Replies Created

Viewing 15 posts - 3,241 through 3,255 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/15/2016)

    GilaMonster (4/15/2016)

    *sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx

    I don't have backup.

    How does one get incorrect page IDs in the headers?

    Seriously. I'm trying to figure out how that one is possible.

    Pages zeroed out by...

    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

    April 15, 2016 at 6:30 am

    #1872304

  • RE: .mdf file is not working properly

    What's the latest backup you have?

    Because something (bad IO subsystem usually) has done a lot of damage to that file, it's not repairable.

    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

    April 15, 2016 at 4:47 am

    #1872271

  • RE: .mdf file is not working properly

    I am not asking for the errors you get when querying. I need to see messages relating to this database from the error log. They are not the same thing....

    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

    April 15, 2016 at 4:14 am

    #1872266

  • RE: Are the posted questions getting worse?

    *sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx

    I don't have backup.

    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

    April 15, 2016 at 4:11 am

    #1872265

  • RE: .mdf file is not working properly

    GilaMonster (4/15/2016)

    What are the errors related to this database in the errorlog?

    In addition to getting those errors (which I really need to see), please run the following (exactly that command...

    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

    April 15, 2016 at 4:05 am

    #1872263

  • RE: .mdf file is not working properly

    You've got corruption in your DB. Either the DB was corrupt before you tried moving it and you didn't notice, or it was damaged in the move.

    What are 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

    April 15, 2016 at 3:52 am

    #1872260

  • RE: .mdf file is not working properly

    Do you have a backup?

    What are the error messages in the error log relating to this DB?

    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

    April 15, 2016 at 3:30 am

    #1872256

  • RE: which update for which nested transaction

    EamonSQL (4/14/2016)

    Is it possible to find out which updates were made against a first, second, third etc nested transactions?

    For example, if select @@trancount returns 4 can I find out what...

    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

    April 15, 2016 at 2:55 am

    #1872251

  • RE: Always ON

    You'd need to shut down the SQL instance in order to copy the files. SQL keeps the files open while it's running, no matter what activity there is on 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

    April 15, 2016 at 2:42 am

    #1872245

  • RE: Disabling 'sa'. What Account for system processes ??

    They'd run under 'sa'

    Disabling the account means no one can log in as it. The system processes don't need to log in.

    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

    April 15, 2016 at 2:29 am

    #1872242

  • RE: How do I get a multi user table created without DBA involved?

    matak (4/14/2016)

    Global temp tables will help ## instead of #.

    Just keep in mind they will disappear with every sql service restart.

    And when the connection which created them closes and 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

    April 15, 2016 at 2:19 am

    #1872240

  • RE: Timeouts in SQL Server 2008 r2 Clustered Environment

    Timeout is a client setting, not a server setting. It's nothing to do with cluster settings.

    Timeout is the client saying it's waited too long for a database query to execute...

    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

    April 15, 2016 at 2:15 am

    #1872238

  • RE: Who's going to SQL Bits in Liverpool?

    🙁 :crying:

    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

    April 13, 2016 at 5:59 am

    #1871653

  • RE: System databases not backing up

    Rechana Rajan (4/13/2016)

    tmmutsetse (4/13/2016)

    Hie i am new on this forum,please advise i do my back ups via a sql server agent job which ecxecutes a stored procedure

    EXECUTE...

    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

    April 13, 2016 at 5:47 am

    #1871644

  • RE: Not able to restore DB in SQL 2014

    And if you do the restore in T-SQL?

    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

    April 13, 2016 at 4:45 am

    #1871632

Viewing 15 posts - 3,241 through 3,255 (of 49,552 total)