Forum Replies Created

Viewing 15 posts - 5,191 through 5,205 (of 9,722 total)

  • RE: Transaction Log File "Does not Exist" - Help, please

    Jack Corbett (10/20/2011)

    The only time I've seen this is with tempdb and a SQL Server Service restart fixes that.

    A restart might fix this as well. This may not...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 9:42 am

    #1397508

  • RE: Transaction Log File "Does not Exist" - Help, please

    george sibbald (10/20/2011)

    If you have a full backup I would be interested to see which files are returned by restore filelistonly.

    DAMN. I forgot we're using non-SQL native DeDup backup technology...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 9:07 am

    #1397476

  • RE: Transaction Log File "Does not Exist" - Help, please

    Stefan Krzywicki (10/20/2011)

    If you backup the transaction log and change the Recovery Mode to Simple you should be able to delete the second file. Then you can change it back...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 8:58 am

    #1397467

  • RE: Transaction Log File "Does not Exist" - Help, please

    Stefan Krzywicki (10/20/2011)

    If you backup the transaction log and change the Recovery Mode to Simple you should be able to delete the second file. Then you can change it back...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 8:50 am

    #1397447

  • RE: Transaction Log File "Does not Exist" - Help, please

    So I tried the "hack" in the MS Connect item (see my earlier post for the link) and it doesn't work for me. As soon as I try to add...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 8:44 am

    #1397431

  • RE: Transaction Log File "Does not Exist" - Help, please

    Roy Ernest (10/20/2011)

    Brandie, I think there is another one cause I remember distinctly that you have to do a EMPTYFILE before you try to delete the secondary file once again...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 8:32 am

    #1397415

  • RE: Transaction Log File "Does not Exist" - Help, please

    george sibbald (10/20/2011)

    whats the state_desc value in sys.master_files for this offending log file?

    ONLINE

    george sibbald (10/20/2011)

    If you have a full backup I would be interested to see which files are returned...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 8:13 am

    #1397392

  • RE: Transaction Log File "Does not Exist" - Help, please

    calvo (10/20/2011)

    Just throwing this out there, would running checkdb provide any clues?

    Just finished running it, MOF. It didn't find any problems with the database. Also ran it against MASTER (because...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 6:49 am

    #1397295

  • RE: Transaction Log File "Does not Exist" - Help, please

    I don't want to recreate the file, actually. I just want to remove it.

    Changing my T-SQL statement to REMOVE FILE I get:

    Msg 5009, Level 16, State 9, Line 2

    One...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 6:34 am

    #1397290

  • RE: Are the posted questions getting worse?

    Grrrr. Me be troll. "PANTS! PANTSPANTSPANTS! I dare you! GRRRRRR".

    And on a more serious note, I need help badly, please. This one has me totally confused and I can't seem...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 6:17 am

    #1397271

  • RE: Are the posted questions getting worse?

    OMG! It's back! It's really really back!

    http://www.commodoreusa.net/CUSA_Vision.aspx

    I have such fond memories of my state-of-the-art Commodore 64. Now I can get a new one! @=)

    Soon as I can scrape up some...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2011 at 4:57 am

    #1397210

  • RE: Are the posted questions getting worse?

    Harold and Kumar get pantsed.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 19, 2011 at 10:12 am

    #1396768

  • RE: Today's Random Word!

    Ray K (10/19/2011)

    crookj (10/18/2011)

    WOTD - enhancement

    Viagra

    Lyrica

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 19, 2011 at 7:31 am

    #1396627

  • RE: Are the posted questions getting worse?

    Am I pants? Do I even look like pants? Trust me. I'm a doctor.

    EDIT:

    Amy Pond, there's something you better understand about me 'cause it's important. And one day your life...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 19, 2011 at 6:46 am

    #1396601

  • RE: Are the posted questions getting worse?

    Of course, you realize, this means pants!

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 18, 2011 at 1:15 pm

    #1396291

Viewing 15 posts - 5,191 through 5,205 (of 9,722 total)