Forum Replies Created

Viewing 15 posts - 40,141 through 40,155 (of 49,552 total)

  • RE: Recover SQL 2005 (Comp. lvl 80) DB on SQL 2000

    david.griswold (3/26/2009)

    I will give up on this then and tell my boss we need another SQL 2005 server if we are going to have any type of failover server, cold,...

    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

    March 26, 2009 at 1:30 pm

    #967004

  • RE: Weird Issue

    SQL ORACLE (3/26/2009)

    Gilamonster:

    The error message is in the top post. What I changed is only the database name.

    That's not the complete error. The job history cuts off after a certain...

    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

    March 26, 2009 at 1:21 pm

    #966998

  • RE: sqlmaint.exe failed

    Uncheck the checkbox that says 'automatically repair minor errors' It's a bad idea to have it checked anyway.

    Are you sure the checkDB returned no errors on any of the DBs?

    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

    March 26, 2009 at 1:08 pm

    #966983

  • RE: sqlmaint.exe failed

    Go into the job step and set it to log to an output file. That way, hopefully, you can see the entire message.

    Since it's the db integrity task, please run...

    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

    March 25, 2009 at 11:09 pm

    #966427

  • RE: Recover SQL 2005 (Comp. lvl 80) DB on SQL 2000

    david.griswold (3/25/2009)

    So, I copied them to my SQL 2005 server put the MDFs on the data drive, the LDFs on the Logs drive, fired up SQL Server Management Studio (who...

    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

    March 25, 2009 at 10:57 pm

    #966423

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/25/2009)

    RBarryYoung (3/25/2009)

    I tried deleting the duplicates, but I don't think that Steve allows us to do that anymore.

    I thought it was just me... and yeah, I can't delete...

    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

    March 25, 2009 at 1:52 pm

    #966254

  • RE: Speaking at PASS

    Brandie Tarvin (3/25/2009)

    Since I've never been to a PASS before, I'm wondering what level of sessions they want

    From what I've seen, everything from level 200 up to level 500.

    and...

    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

    March 25, 2009 at 1:37 pm

    #966238

  • RE: query execution

    umar iqbal (3/25/2009)

    we alredy know command is "Alter Login "

    Not on SQL 2000 it wouldn't have been.

    Krishna (3/25/2009)

    Enable Defualt trace and ...

    SQL 2000 forum.

    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

    March 25, 2009 at 1:36 pm

    #966237

  • RE: Bulk logged Recovery model

    In bulk logged certain operations (I'm not listing the full set, there are a number of complexities) are bulk logged instead of full logged. That means that instead of each...

    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

    March 25, 2009 at 9:27 am

    #966042

  • RE: Are the posted questions getting worse?

    RBarryYoung (3/25/2009)

    You know I am not getting my email alerts/updates this morning either. Something is definitely off.

    Likewise. I've had one notification since about 9am this morning (GMT+2).

    I promise...

    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

    March 25, 2009 at 9:22 am

    #966038

  • RE: can we re store in db just one table

    steve block (3/25/2009)

    I'm not sure if this is available in 2005 or 2008.

    It's not, and it's highly unlikely that it will be available in future versions.

    MS is against giving...

    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

    March 25, 2009 at 9:20 am

    #966035

  • RE: query execution

    J.K (3/25/2009)

    And now i just want to check which all queries i had executed the very last day.I mean i want to know which all queries i had executed for...

    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

    March 25, 2009 at 9:15 am

    #966033

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/24/2009)

    I agree with Gail... that moron (actually he's more off than on :-P) is on my permanent black list just because he can't control himself.

    I take people...

    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

    March 25, 2009 at 2:48 am

    #965843

  • RE: Do DBAs Still Read Techincal Books?

    Jeff Moden (3/24/2009)

    dwithroder (3/24/2009)

    I have an hour long commute, so I read.

    BWAA-HAA!!! Hopefully, you're not the one driving. 😛

    I used to read while driving to work. 😀

    I used to have...

    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

    March 25, 2009 at 2:36 am

    #965839

  • RE: Database Recovery Help

    angels4kali (3/24/2009)

    For that matter, all my databases, including those that weren't dropped think they had a full backup taken on 3/15 and none of the full backup files exist

    Any idea...

    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

    March 24, 2009 at 2:08 pm

    #965586

Viewing 15 posts - 40,141 through 40,155 (of 49,552 total)