Forum Replies Created

Viewing 15 posts - 36,541 through 36,555 (of 49,552 total)

  • RE: Replacing log shipping with robocopy

    Indianrock (9/7/2009)

    Since we need to set the database in simple recovery every few months for various projects.....

    Why?

    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

    September 8, 2009 at 1:02 am

    #1050328

  • RE: How can you be sure your backup doesnt contain corrupt data?

    winston Smith (9/7/2009)

    Cool. thanks for the answers. im just wondering as if such an issue occured, and you had to restore, chances are you dont have time to restore a...

    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

    September 8, 2009 at 12:58 am

    #1050327

  • RE: How to get new tables to point to new data file

    jymoorthy (9/7/2009)

    In case, if you have created the new file in the same file group (PRIMARY), then you may stop the grow option on the old file and enable grow...

    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

    September 8, 2009 at 12:56 am

    #1050326

  • RE: Non-Clustered Indexes Query Performance

    If you add 3 indexes each on a single column, SQL will likely use only one of them. There is something called index intersection, where SQL will seek on multiple...

    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

    September 8, 2009 at 12:53 am

    #1050323

  • RE: How to Recover Data If Mdf File is Corrupt or Damaged

    Look up Tail-log backup in SQL's books online (I'm not going to outright give you the answer to an interview question)

    However that's only an option if the DB is 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

    September 8, 2009 at 12:43 am

    #1050318

  • RE: MSDB suspect... cant do anything

    Ok, I was after the original error messages about MSDB when it was marked suspect. Do you perhaps have that?

    The error after adding the traceflag indicates that you added 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

    September 8, 2009 at 12:40 am

    #1050316

  • RE: do checkpoints affect log chains?

    winston Smith (9/6/2009)

    I restore the full backup and 22 logs taken between 00:00 and 11:00.

    Well, after then log truncation at 09:45, all log backups would have failed, so when...

    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

    September 7, 2009 at 1:13 am

    #1050000

  • RE: MSDB suspect... cant do anything

    Chirag (9/6/2009)

    "Error 3(The system cannot find the path specified.) occurred while opening file 'master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify...

    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

    September 7, 2009 at 1:09 am

    #1049999

  • RE: SQL 2008 Audit parameterized

    Continued here: http://www.sqlservercentral.com/Forums/Topic783364-1550-1.aspx

    No replies to this thread please.

    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

    September 5, 2009 at 12:31 pm

    #1049777

  • RE: fatal error 644

    Is there a question here?

    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

    September 5, 2009 at 12:30 pm

    #1049776

  • RE: dbcc updateusage

    charipg (9/4/2009)

    i want to schedule a job with dbcc updateusage(dbname) then run the dbcc sqlperf (logspace) in the same job.

    Why? What's the purpose of UpdateUsage in there?

    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

    September 5, 2009 at 10:19 am

    #1049755

  • RE: Unique Index Causing Slow Read Performance

    ben.mcintyre (9/4/2009)

    Gail, I am still interested in what is going on here, specifically that the single change in an index from unique to nonunique can flip the query plan on...

    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

    September 5, 2009 at 2:13 am

    #1049698

  • RE: Exception 253 caught at line 446 of file e:\sql9_sp2_t\sql\komodo\src\core\sqlagent\src\job.cpp. SQLServerAgent initiating self-termination

    nitin.doshi (9/4/2009)

    Hi,

    Have U got resolution to this problem. Because we are also facing same problem.

    As I said to the OP, this is probably something that will require contacting customer support.

    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

    September 5, 2009 at 2:05 am

    #1049696

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (9/4/2009)

    Anyhow, strange that the sore muscles I had from Wednesday's session seem to have magically (almost) disappeared after another session tonight, and not an easy...

    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

    September 4, 2009 at 4:14 pm

    #1049639

  • RE: Password Vulnerability in SQL 2005 and 2000

    Steve Jones - Editor (9/4/2009)

    However since so many people use the same pwd on other systems, getting the hash from SQL and cracking it (or from memory), could be an...

    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

    September 4, 2009 at 3:57 pm

    #1049637

Viewing 15 posts - 36,541 through 36,555 (of 49,552 total)