Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 49,552 total)

  • RE: Can I recover Missing Database File From Backup?

    lmarkum (7/1/2016)

    The database is in Simple recovery and we keep one full backup at a time. Looks like based on the below I would be out of luck because...

    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

    July 1, 2016 at 8:39 am

    #1888107

  • RE: Can I recover Missing Database File From Backup?

    Providing you are in full recovery model and have an unbroken chain of log backups from before the full backup until now.

    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

    July 1, 2016 at 8:07 am

    #1888097

  • RE: EXEC sp_executesql

    Comment out the EXEC and print out the resultant SQL statement, that way you should be able to see what's wrong with it.

    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

    July 1, 2016 at 7:33 am

    #1888088

  • RE: Trouble with Restore The backup set holds a backup of a database other than the existing database.

    Welsh Corgi (7/1/2016)

    What do I need to do?

    Msg 3234, Level 16, State 2, Line 2

    Logical file ' PrismData_FG2_0' is not part of database 'PrismDataBillingTest'. Use RESTORE FILELISTONLY to list 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

    July 1, 2016 at 6:09 am

    #1888069

  • RE: EXEC sp_executesql

    Add [ before and ] after the database name when you build up the script.

    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

    July 1, 2016 at 6:08 am

    #1888068

  • RE: Trouble with Restore The backup set holds a backup of a database other than the existing database.

    Welsh Corgi (7/1/2016)

    GilaMonster (7/1/2016)

    As John said, add the REPLACE option to your restore statement.

    See https://msdn.microsoft.com/en-us/library/ms186858.aspx for the options and syntax for a RESTORE

    ok, I'm tired could you please help me...

    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

    July 1, 2016 at 6:08 am

    #1888067

  • RE: Trouble with Restore The backup set holds a backup of a database other than the existing database.

    As John said, add the REPLACE option to your restore statement.

    See https://msdn.microsoft.com/en-us/library/ms186858.aspx for the options and syntax for a 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

    July 1, 2016 at 4:18 am

    #1888036

  • RE: Restore Database Syntax

    No further replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1798979-3739-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

    July 1, 2016 at 4:16 am

    #1888035

  • RE: Deadlock on simple query

    Screen shots of the graph are nearly useless, all the interesting information is in tooltips. Please either attach the deadlock graph file or paste the XML

    Also the table definition 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

    June 30, 2016 at 11:38 am

    #1887942

  • RE: Cascade Delete

    Duplicate post. No replies please.

    Replies to http://www.sqlservercentral.com/Forums/Topic1798746-2799-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

    June 30, 2016 at 7:31 am

    #1887873

  • RE: SQL Server 2016 is Out and It's Fabulous!

    manie (6/30/2016)

    GilaMonster (6/30/2016)

    But surely you picked the DB Mail problem up in your pre-upgrade testing?

    No, I am afraid you have me. I did not test it as I am sure...

    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

    June 30, 2016 at 6:24 am

    #1887840

  • RE: Deadlocks with Object Locks - NO objectids

    The graph's pretty, but far from adequate for solving deadlocks, I never use it, when I teach deadlocks I show the XML only.

    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

    June 30, 2016 at 1:18 am

    #1887784

  • RE: SQL Server 2016 is Out and It's Fabulous!

    But surely you picked the DB Mail problem up in your pre-upgrade testing?

    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

    June 30, 2016 at 1:17 am

    #1887783

  • RE: t-sql 2012 add data row to temp table

    select EndYear, SchoolYear, Active from #UserCalendar

    where (active = 1 OR EndYear = 2017)

    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

    June 29, 2016 at 4:02 pm

    #1887752

  • RE: CTE Script Needed for delete statement

    LinksUp (6/29/2016)

    Sree Divya (6/29/2016)

    thanks

    can you please share the code

    how to delete by batch wise

    That is something only you can answer. I have no idea what your table looks like 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

    June 29, 2016 at 3:58 pm

    #1887750

Viewing 15 posts - 2,851 through 2,865 (of 49,552 total)