Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 9,715 total)

  • RE: .mdf file is not working properly

    Grant Fritchey (4/15/2016)


    Backups. What are they good for?[/url]

    and, more recently:

    How to recover from deleting everything, including the backups

    I sincerely hope that this data is not vital to your organization, 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.

  • RE: Are the posted questions getting worse?

    Jack Corbett (4/15/2016)


    Grumpy DBA (4/15/2016)


    (why are mdf and ldf files on the same drive?)

    mdf and ldf on the same drive happens all the time. Of course when...

    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?

    GilaMonster (4/15/2016)


    Brandie Tarvin (4/15/2016)


    BLOB_EATER (4/15/2016)


    GilaMonster (4/15/2016)


    *sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx

    I don't have backup.

    I read "by creating empty DB and taking it offline and deleting and replacing dummy .mdf and .ldf files with my...

    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?

    GilaMonster (4/15/2016)


    Brandie Tarvin (4/15/2016)


    GilaMonster (4/15/2016)


    *sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx

    I don't have backup.

    How does one get incorrect page IDs in the headers?

    Seriously. I'm trying to figure out how that one is possible.

    Pages zeroed out...

    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?

    Ed Wagner (4/15/2016)


    Brandie Tarvin (4/15/2016)


    GilaMonster (4/15/2016)


    *sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx

    I don't have backup.

    How does one get incorrect page IDs in the headers?

    Seriously. I'm trying to figure out how that one is possible.

    I think...

    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?

    BLOB_EATER (4/15/2016)


    GilaMonster (4/15/2016)


    *sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx

    I don't have backup.

    I read "by creating empty DB and taking it offline and deleting and replacing dummy .mdf and .ldf files with my DB".... and just...

    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?

    GilaMonster (4/15/2016)


    *sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspx

    I don't have backup.

    How does one get incorrect page IDs in the headers?

    Seriously. I'm trying to figure out how that one is possible.

    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?

    Ummmm. Ouch?

    Or does this really matter[/url] to anyone?

    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: Potential presentation idea: The role of documentation in disaster recovery

    crmitchell (4/14/2016)


    Ray K (3/11/2016)


    I'll also mention that all of our documentation was in hardcopy format and stored as Word/Visio/PDF files. (At the time, online documentation was still a foreign...

    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?

    Has the transfer stuff improved since 2k5?

    I remember trying it and it failing because it tried to create things in the wrong order. Dependencies were created before their precedents. At...

    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?

    Ed Wagner (4/11/2016)


    Hugo Kornelis (4/11/2016)


    I need some help in this topic.

    Short story: OP tries to give users access to a view but not to a base table. First went about...

    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?

    Most of the tables I have fitting that description are Staging tables which import data from other sources so I can massage it and stick it in my data warehouse....

    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: Running SQL Agent job with SysAdmin access fails due to SSIS access error

    Jack Corbett (4/8/2016)


    Brandie,

    A couple of things:

    1. How did you deploy the packages to msdb? I haven't used msdb with 2012 as we are using the project deployment...

    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: Running SQL Agent job with SysAdmin access fails due to SSIS access error

    Oh for freakin' heaven's sake.

    After everything we've done and gone through, including restarting services and rebooting the server twice...

    There were a couple of issues I could have prevented. When...

    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: Running SQL Agent job with SysAdmin access fails due to SSIS access error

    ttdeveloper (4/8/2016)


    Unfortunately we've already done that

    And by this you mean the service account that's calling the agent jobs correct?

    And our DBA user account group just for kicks and giggles.

    Wow -...

    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 - 1,846 through 1,860 (of 9,715 total)