Forum Replies Created

Viewing 15 posts - 5,176 through 5,190 (of 9,715 total)

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

    Perry Whittle (10/24/2011)


    Brandie i have seen similar to this before, what is the recovery model of the database, if full do you take transaction log backups of this database?

    Yes to...

    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.

  • RE: Are the posted questions getting worse?

    HowardW (10/24/2011)


    Jeff Moden (10/24/2011)


    HowardW (10/24/2011)


    Just came across this:

    http://sqlserverboost.info/?p=204

    Complete plagiarism, yes?[/url]

    The rest of the site content looks equally dubious.

    Google for the phrase "In my experience, every DBA has his own mental...

    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.

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

    It looks like I will have to get Microsoft involved in this one. I can't get the DAC account from corporate because I don't have remote server access. They have...

    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.

  • RE: Are the posted questions getting worse?

    Jack Corbett (10/20/2011)


    On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?

    What sort of presentations have you...

    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.

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

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

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

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

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

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

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

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

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

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

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

Viewing 15 posts - 5,176 through 5,190 (of 9,715 total)