Forum Replies Created

Viewing 15 posts - 34,696 through 34,710 (of 49,552 total)

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    http://www.veloci-group.com/remotebackup.html (1/15/2010)

    But if I do the same thing, but now there's a second full backup (to NAS) in between 2 log backups...... You say to me that it would...

    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 15, 2010 at 6:54 am

    #1104168

  • RE: SQL Server Indexing

    You mean test how much it will help without creating it? No.

    Create the index on a test system, test the queries, see if the new index improves them, if so...

    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 15, 2010 at 5:10 am

    #1104126

  • RE: The Price of SQL Server

    Randolph Potter (1/15/2010)

    One thing I've been begging Microsoft for, is country-specific pricing. I'm pretty sure this is difficult to manage to avoid abuse, but it would make it more affordable,...

    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 15, 2010 at 2:29 am

    #1104096

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    Jeffrey Williams-493691 (1/14/2010)

    Gail - the concern I would have here is that the OP is looking at automating the process. Once automated, everyone forgets that it is 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

    January 15, 2010 at 1:52 am

    #1104089

  • RE: recovery mode

    Is the state 'recovering'? (check sys.databases)

    If so, look in the error log, there'll be lots of messages saying that the database is recovering and how much longer is estimated. All...

    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 15, 2010 at 1:38 am

    #1104086

  • RE: SQL Server Indexing

    scziege (1/14/2010)

    Can someone tell me if an covered index (RecordId,CreationDate) increase the query performance ?

    Yes.

    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 15, 2010 at 1:33 am

    #1104085

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    http://www.veloci-group.com/remotebackup.html (1/15/2010)

    GilaMonster (1/14/2010)

    Are you using differential backups? If not, there's no real reason to take copy-only backups.

    We have remotebackup of the SQL server. We can't restore from LOG backup if...

    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 15, 2010 at 1:30 am

    #1104083

  • RE: SQl Server log files

    fizzleme (1/14/2010)

    Not the error log. The standard SQL log files.

    The 'standard SQL log file' is the error log.

    Visible in SSMS, gives details on login failures, startup messages, etc. 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 15, 2010 at 1:29 am

    #1104082

  • RE: SQl Server log files

    Which log files? Error log?

    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 14, 2010 at 3:09 pm

    #1103986

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    Are you using differential backups? If not, there's no real reason to take copy-only backups.

    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 14, 2010 at 3:07 pm

    #1103983

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    homebrew01 (1/13/2010)

    Why do you want scheduled COPY ONLY backups ? That function is usually used for one-time backups that will not affect the log chain.

    No, it is used (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

    January 14, 2010 at 2:25 pm

    #1103964

  • RE: Incorrect syntax error T-SQL SP SS2K5

    Troy G-471787 (1/14/2010)

    If you truly have the need to pass in the "boundaries" that way then your best bet is to pass them both in individually and construct dynamic 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

    January 14, 2010 at 2:20 pm

    #1103958

  • RE: Incorrect syntax error T-SQL SP SS2K5

    Randy Anthony (1/14/2010)

    Ok, so setting this:

    If @AuditYear = 1 Set @AuditQuesTypeParameter = '1 And 4'

    Else

    Set @AuditQuesTypeParameter = '13 And 16'

    and expecting this:

    And tblAuditQuesLkup.AuditQuesType BETWEEN @AuditQuesTypeParameter...

    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 14, 2010 at 2:19 pm

    #1103956

  • RE: selecting TOP row from a result set

    Welsh Corgi (1/14/2010)

    The requirement requires that was provided is to return the first record created.

    Then your order by needs to be on a column that stores the date...

    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 14, 2010 at 2:16 pm

    #1103955

  • RE: Page error

    And the definition of the clustered index (data types of the key columns)?

    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 14, 2010 at 2:16 pm

    #1103953

Viewing 15 posts - 34,696 through 34,710 (of 49,552 total)