Forum Replies Created

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

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

  • RE: copy files created in a folder two Months ago to another folder

    Then it's my bad.

    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: copy files created in a folder two Months ago to another folder

    opc.three,

    I think you're mixing this post up with another thread. There is no requirement for 60 days in the OP that I can see. The OP says "all files."

    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

    You can query on sys.Filegroups.

    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.caines (6/20/2011)


    They appear to be, if I query sys.master_files:

    CCT_MSCRME:\DATA\CCT_MSCRM.mdf 0ONLINE

    CCT_MSCRM_logF:\LOGS\CCT_MSCRM_log.LDF 0ONLINE

    FYI: Your .mdf file is not the same as a...

    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: SSRS 2005

    ravisamigo (6/20/2011)


    How can I configure that database server to reportserver to generate Reports?

    Ravi, looking at this question, I just realized I don't understand what you mean by it. Could 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: Cannot perform a differential backup for database "ABC", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.

    Grant Fritchey (6/20/2011)


    polasabhushan (6/20/2011)


    But I can say that, before taking a full or differential backup, we are truncating log by changing recovery model from bulk-logged to simple and again 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: Cannot perform a differential backup for database "ABC", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.

    polasabhushan (6/20/2011)


    But I can say that, before taking a full or differential backup, we are truncating log by changing recovery model from bulk-logged to simple and again to bulk-logged.

    That's your...

    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,715 total)