Forum Replies Created

Viewing 15 posts - 7,801 through 7,815 (of 9,720 total)

  • RE: Password change error

    Was the login able to log into the system before the change password attempt? Is it still able to login now? (Just verifying the change is the only thing you've...

    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.

    July 29, 2010 at 10:43 am

    #1199928

  • RE: Buffer Pool information/usage

    Whoops, I must have mixed up those two fields when I read the snippet. My bad.

    What is the priority on your Server Properties Processors tab? And what else do 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.

    July 29, 2010 at 10:34 am

    #1199919

  • RE: Are the posted questions getting worse?

    GilaMonster (7/29/2010)

    If you look, it didn't go suspect. It went recovery_pending. That's because the corruption was encountered while opening the file. To get it suspect, the corruption has 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.

    July 29, 2010 at 9:04 am

    #1199862

  • RE: linked server catalogs not showing on client SSMS.

    Dana Bibeault (7/29/2010)

    Can't see them in the user GUI. I can see them as administrator on my gui and on the server.

    strangely, if the user goes to another PC,...

    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.

    July 29, 2010 at 9:00 am

    #1199858

  • RE: Are the posted questions getting worse?

    GilaMonster (7/29/2010)

    Results of test:

    ....

    If you're interested in repo:

    ....

    -- open mdf in hex editor at this point and overwrite part of the first couple pages.

    Is this what you did 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.

    July 29, 2010 at 8:49 am

    #1199846

  • RE: Buffer Pool information/usage

    I'm not sure setting Min Memory to the same amount as Max Memory is an optimal solution, SQLBuddy. Once SQL reaches that 3GB, it won't free up memory from the...

    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.

    July 29, 2010 at 8:45 am

    #1199840

  • RE: linked server catalogs not showing on client SSMS.

    Is the problem that he can't see them in the GUI or that he can't use them or both?

    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.

    July 29, 2010 at 8:34 am

    #1199828

  • RE: Help with Sql Stroge switch

    It depends on what they're actually doing. Are they swapping old disks for new disks? Or just the software used to control the disks?

    If the later, they'll backup the data...

    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.

    July 29, 2010 at 8:31 am

    #1199826

  • RE: Are the posted questions getting worse?

    DOH. Sorry. :pinch:

    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.

    July 29, 2010 at 8:13 am

    #1199816

  • RE: Today's Random Word!

    crookj (7/29/2010)

    dbowlin (7/29/2010)

    Let's do the timewarp again:cool:

    It's just a jump to the left

    And then a step to the right

    With your hands on your hips

    You bring your knees in tight

    But it's...

    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.

    July 29, 2010 at 7:59 am

    #1199807

  • RE: Are the posted questions getting worse?

    Paul White NZ (7/29/2010)

    BTW I say 'darn near impossible' because I have never tried to back up the tail of the log for a damaged simple-mode database. I would...

    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.

    July 29, 2010 at 7:57 am

    #1199804

  • RE: Connections & Sessions

    ggjjbb1983 (7/28/2010)

    1. 3. For example, how many sessions can a connection have and vice versa.

    Depends on how your server is set up, how many CPUs you have, how heavy the...

    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.

    July 29, 2010 at 7:20 am

    #1199776

  • RE: Connections & Sessions

    I could be wrong about this, but this is how I understand it.

    Sessions "contain" connections.

    A query can connect with multiple threads to the server to assist with performance and...

    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.

    July 29, 2010 at 7:10 am

    #1199766

  • RE: Today's Random Word!

    Hee. @=)

    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.

    July 29, 2010 at 6:56 am

    #1199750

  • RE: Are the posted questions getting worse?

    GilaMonster (7/29/2010)

    What probably would work is, at the point of the 'oops', take the DB offline, copy the files elsewhere (both mdf and ldf), attach as new DB and mark...

    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.

    July 29, 2010 at 6:54 am

    #1199749

Viewing 15 posts - 7,801 through 7,815 (of 9,720 total)