Forum Replies Created

Viewing 15 posts - 6,976 through 6,990 (of 49,552 total)

  • RE: Best scenario for high DB availability

    choudhury.pradeep (12/23/2014)

    Understand Restoring is not same to recovery. The full story is, in the morning I restarted the DB server, after restart when I open SSMS I check the 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

    December 23, 2014 at 5:12 am

    #1766165

  • RE: Database Restore Problem

    shohelr2003 (12/23/2014)

    a) Then what does "Compatability Level" do here?

    Change the behavior of the query processor

    b) And what to do in this scenario?

    Restore to a 2012 server, or script and recreate...

    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

    December 23, 2014 at 5:02 am

    #1766162

  • RE: Database Restore Problem

    You cannot restore down-version.

    A database attached to a SQL 2012 server is a SQL Server 2012 database and cannot be restored to a SQL 2008 R2 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

    December 23, 2014 at 3:46 am

    #1766151

  • RE: Connection problems to SQL Server Central site

    The servers are the UK, not Toronto, it's not a wordpress site either. They don't have regularly scheduled maintenance daily. Something probably broke today.

    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

    December 23, 2014 at 3:23 am

    #1766143

  • RE: Backups to tape - how to check.

    If the backup is to tape, there has to be a tape drive in the server, the backup will be very, very slow and the physical device is something like...

    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

    December 23, 2014 at 3:19 am

    #1766141

  • RE: Backups to tape - how to check.

    Joy Smith San (12/23/2014)

    By checking the physical_device_name, I assume it's directly taken to tape.

    What in the physical name leads to that assumption?

    Is there anyway to find ourselves how the 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

    December 23, 2014 at 3:11 am

    #1766137

  • RE: re-vamping data files in a production database

    First things first.

    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

    December 23, 2014 at 1:42 am

    #1766128

  • RE: SQL Server 2012 64bit uses 95% Memory available..

    There is nothing unusual about SQL using most of the memory on the server, that's how it's designed to work. You need to ensure that you have set max 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

    December 23, 2014 at 1:40 am

    #1766127

  • RE: Are the posted questions getting worse?

    Jeff Moden (12/22/2014)

    GilaMonster (12/22/2014)

    Someone, please, help! http://www.sqlservercentral.com/Forums/Topic1645843-1549-1.aspx

    Heh... WHAT? Nah... he doesn't need any help. He only lost 1 day of business. :-):-D:-P

    Wrong target. I need the help after...

    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

    December 23, 2014 at 1:36 am

    #1766125

  • RE: DEADLOCK : System tables

    If you shut down Spotlight, does the deadlock go away? If so, time to call 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

    December 22, 2014 at 9:27 am

    #1766013

  • RE: Are the posted questions getting worse?

    Someone, please, help! http://www.sqlservercentral.com/Forums/Topic1645843-1549-1.aspx

    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

    December 22, 2014 at 9:26 am

    #1766012

  • RE: Manually "refreshing" subscriber database in transactional replication

    zoggling (12/22/2014)

    Is there definitely no T-SQL way of pushing all outstanding changes across,

    As I said, you can drop the subscriber and re-snapshot. That'll do what you want....

    or manually calling...

    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

    December 22, 2014 at 8:33 am

    #1765994

  • RE: CHECK DB on SQL 2008 and SQL 2005

    A trivial google search (bug SQL Server 2005 CheckDB maintenance plan) turns up http://www.sqlskills.com/blogs/paul/sql-2005-sp2-maintenance-plan-bug-masking-corruption/

    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

    December 22, 2014 at 8:30 am

    #1765993

  • RE: Best scenario for high DB availability

    choudhury.pradeep (12/22/2014)

    The situation is not often on restart and occur rarely. Please clarify me, if the DB is in state of Restoring, can I recover the DB using command "restore...

    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

    December 22, 2014 at 8:26 am

    #1765992

  • RE: Initialize sp parameter using a select statement

    John Mitchell-245523 (12/22/2014)

    Yes, I did consider that, but then I noted that could equally be the case if a value of 1 and value of 1,000,000 were passed in 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

    December 22, 2014 at 7:16 am

    #1765978

Viewing 15 posts - 6,976 through 6,990 (of 49,552 total)