Forum Replies Created

Viewing 15 posts - 5,671 through 5,685 (of 9,722 total)

  • RE: Today's Random Word!

    Plume

    As in ... MORE FREAKING SMOKE. GAH. Someone fetch me a new pair of lungs.

    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?

    Can someone who knows something about offline files / filegroups, backups and full text indexes help out here:

    http://www.sqlservercentral.com/Forums/Topic1128022-357-1.aspx?Update=1

    OP seems to think the problem is his Full Text Indexes, but I'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.

  • RE: The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online

    I almost hate to suggest this, but you might need to do an ALTER DATABASE <MyDB> MODIFY FILEGROUP to see if you can trick the server into thinking the filegroup...

    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: The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online

    Chris,

    I haven't forgotten you. I'm just trying to figure out why your server thinks the filegroup or the file within it is offline. Because that does appear to be 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.

  • RE: Backup Duration

    Perry Whittle (6/21/2011)


    Brandie Tarvin (6/21/2011)


    Perry Whittle (6/21/2011)


    you dont seem to have made any provision for scenarios when a database name is passed in that is in Simple recovery mode

    Apparently, I'm...

    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: Named Pipes Provider: Could not open a connection to SQL Server [53]

    Glad you found your issue and thanks for posting the details about it.

    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: how many sql server error logs are there? from within sql.

    jessyb (6/21/2011)


    Thank you both for your time & help. I do appreciate it.

    xp_enumerrorlogs is perfect - can't believe I didn't find it before.

    Me too. That's definitely one that'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.

  • RE: Database ID 6, Page (1:1324) is marked RestorePending

    Bhuvnesh (6/22/2011)


    sorry for late reply , i went for conference and came back today itself

    so i ran

    DBCC CheckDB with ALL_ERRORMSGS

    and got below error

    Msg 8921, Level 16, State 1,...

    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: Data nearing to 4GB. is there is a way to extend size?

    Ken Garrett (6/20/2011)


    I think the easiest way to generate Oracle DDL would be to reverse engineer the schema into a Data Modeling tool (if you have one) and then try...

    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: Backup Duration

    Perry Whittle (6/21/2011)


    you dont seem to have made any provision for scenarios when a database name is passed in that is in Simple recovery mode

    Apparently, I'm missing the context of...

    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: linked report

    It does sort of does make sense. And you're correct. There's no way I know of to use the BIDS solution to set up that information.

    Our developers use a SQL...

    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: Named Pipes Provider: Could not open a connection to SQL Server [53]

    Have you had any service pack updates or anything applied to your box or the server recently? Right about the same time that this error started.

    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?

    GSquared (6/21/2011)


    SSIS job and they don't know about derived columns????

    Is that the part where I make something up and hope it fits with the rest of the data?

    @=)

    How can...

    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?

    Steve Jones - SSC Editor (6/20/2011)


    GabyYYZ (6/20/2011)


    Anyone know if he has official Microsoft MVP designation, either now, or in the past?

    AFAIK, he never has. Not enough contributions to the SQL...

    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: Inventory DB Design

    What queries have you tried based on the above table schema?

    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,671 through 5,685 (of 9,722 total)