Forum Replies Created

Viewing 15 posts - 8,431 through 8,445 (of 49,552 total)

  • RE: MSG 3154 The backup set holds a backup of a database other than the existing database.

    sirvikasrana (7/14/2014)

    Here is my Code:

    RESTORE DATABASE SomeDBTest FROM DISK = 'E:\MSSQLBackup\SomeDB.bak'

    WITH RECOVERY, REPLACE,

    MOVE 'SomeDBTest' TO 'E:\MSSQLBackup\SomeDBTest.mdf',

    MOVE 'SomeDBTest_Log' TO 'E:\MSSQLBackup\SomeDBTest_log.ldf'

    ------------------------------

    Msg 3234, Level 16, State 2, Line 2

    Logical file 'SomeDBTest' is...

    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 14, 2014 at 2:13 pm

    #1729270

  • RE: SQL QUERY HELP

    Cool. Read up (in Books Online, the help file) on GROUP BY and Count. That should set you on the right track.

    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 14, 2014 at 2:11 pm

    #1729268

  • RE: Truncating Log File of Replicated Database

    Not the article itself. The kb that it links to which describes a bug with (I think) snapshot replication.

    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 14, 2014 at 2:10 pm

    #1729267

  • RE: MSG 3154 The backup set holds a backup of a database other than the existing database.

    sirvikasrana (7/14/2014)

    Grant Fritchey (7/14/2014)

    sirvikasrana (7/14/2014)

    Hema kumar-337490 (7/14/2014)

    Since you are trying to restore the DB on the same server and both source and destination databases exist exist in the same location....

    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 14, 2014 at 10:40 am

    #1729205

  • RE: MSG 3154 The backup set holds a backup of a database other than the existing database.

    sirvikasrana (7/14/2014)

    GilaMonster (7/14/2014)

    sirvikasrana (7/14/2014)

    Grant Fritchey (7/14/2014)

    Then you need to use WITH MOVE.

    Already doing it, please go through my post carefully

    Regards

    You're specifying logical file names that don't exist. According to 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 14, 2014 at 10:40 am

    #1729204

  • RE: Anyone going to SQL Bits 17-19 June Telford ICC, UK

    rodjkidd (7/14/2014)

    Sadly I have no costume for Friday 🙁

    I'm still working on mine. Dunno how Steampunk it is though. Limited by the requirement it be easy to pack.

    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 14, 2014 at 10:37 am

    #1729203

  • RE: Truncating Log File of Replicated Database

    Also, find my "Why is my transaction log full" article here. There's a link in there to a kb article on a bug in snapshot replication (I think) which can...

    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 14, 2014 at 10:29 am

    #1729200

  • RE: Are the posted questions getting worse?

    I don't know them, but I'm sure that's a temporary condition.

    I will pack my Starflux cards, maybe Avalon too.

    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 14, 2014 at 10:28 am

    #1729198

  • RE: Truncating Log File of Replicated Database

    Merge doesn't use the transaction log. Are you sure there's no transactional replication set up, intentionally or otherwise? Transactional replication is what can prevent log reuse.

    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 14, 2014 at 10:27 am

    #1729197

  • RE: Datatype

    DateTime2 probably

    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 14, 2014 at 10:26 am

    #1729196

  • RE: SQL QUERY HELP

    Read up on GROUP BY and COUNT.

    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 14, 2014 at 9:20 am

    #1729173

  • RE: MSG 3154 The backup set holds a backup of a database other than the existing database.

    sirvikasrana (7/14/2014)

    Grant Fritchey (7/14/2014)

    Then you need to use WITH MOVE.

    Already doing it, please go through my post carefully

    Regards

    You're specifying logical file names that don't exist. According to the error message,...

    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 14, 2014 at 9:09 am

    #1729167

  • RE: MSG 3154 The backup set holds a backup of a database other than the existing database.

    You need to use WITH REPLACE on the restore. Since you're overwriting the DB that's there, I don't understand why you say you can't use that option.

    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 14, 2014 at 8:30 am

    #1729147

  • RE: It seems our sql database is corrupted

    This site is for Microsoft SQL Server. As such, we can't necessarily help with problems on non-SQL Server platforms. You'll probably get better help if you find forums specifically 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

    July 14, 2014 at 7:33 am

    #1729130

  • RE: backup log TO DISK NUL and Database Mirror

    Daily? Does that meet your data loss SLAs in cases where mirroring doesn't help (like an accidentally dropped table)?

    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 14, 2014 at 7:30 am

    #1729128

Viewing 15 posts - 8,431 through 8,445 (of 49,552 total)