Forum Replies Created

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

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

    Jack Corbett (10/20/2011)

    Even though the SQL Server Service ahs been restarted several times, do you know when this issue started? Perhaps after the last restart. I'm not really...

    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 11:29 am

    #1397561

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

    Stefan Krzywicki (10/20/2011)

    Ridiculous question, but when you check the location of the secondary log file with a query, is it reporting the correct location?

    Not at all a ridiculous question.

    It's reporting...

    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 11:28 am

    #1397559

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

    Brandie Tarvin (10/20/2011)

    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...

    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:53 am

    #1397514

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

    Brandie Tarvin (10/20/2011)

    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...

    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:49 am

    #1397512

  • 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

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