Forum Replies Created

Viewing 15 posts - 61 through 75 (of 153 total)

  • RE: Cannot restore database. Cannot get exclusive accesss

    kjgreen1112 (11/29/2013)


    While restoring database in sql server 2012, i am getting the following error in sql server 2012

    "Exclusive access could not be obtained because the database is in use "

    No...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: ASYNC_IO_COMPLETION while BACKUP DATABASE running

    DoolinDalton (11/12/2013)


    Is it normal for this lastwaittype to last for the entire duration of a backup database command? We're seeing the waittime just continue to tick up until the backup...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: SCOM 2012 management pack and/or MDW

    thunderousity (11/22/2013)


    I was using the MDW for a while until I realised that the MDW database size had exploded to 200 GB with about 10 Instances.

    Ensure you configure the...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: IBM XIV Storage Platform

    Hi I wanted to revive this thread to see if anyone has used XIV? Their experiences with it. IBM is now on the "third release" of their Storage Product...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: String or binary data would be truncated. Error when inserting empty table results into TEMP table

    Thanks Koen for the suggestions, I will experiment with this and try to come up with fix/sample for myself.

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: String or binary data would be truncated. Error when inserting empty table results into TEMP table

    Hi Koen, thanks for the insight into SQL, would you happen to have an example of this? (simple one or pseudo code) To be better understand?

    Trying to relate this the...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: String or binary data would be truncated. Error when inserting empty table results into TEMP table

    Thanks for pointing that out, I haven't experienced that before- didn't know that's possible. Ill have to practice/read more on query plans. Ill give that a try tommorow.

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Governing SQL Server agent jobs across SQL instances

    Another is "Tidal enterprise scheduler" it is compatible with unix/linux also.

    It's great product, I can't speak on the others suggested but this one allows for dependencies on jobs regardless,...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Having problem openning SQL scripts

    shashi_1409 (10/20/2013)


    I have some TSQL scripts which ran successfully a week before and now suddenly when I open these files in SSMS its asking me to choose encoding, I am...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Profiler

    If you are using the GUI for Profiler Trace (Taking a guess, but I believe you are)

    Have you considered scripting from your template out with appropriate options to run a...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Trouble shooting cursor

    sorry please delete, I mis-read question.

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Map Network drive not visibile for backup?

    Hi Anada,

    Does your service account has permission to the network share?

    You should be able to navigate to the folder when you are logged into the server and confirm by...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Cannot write an XEL file to my C drive from an Extended Events session

    Could it be possible your SQL Server service acct does not have permissions to the folder? (Try checking permissions to verify?)

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: separate disks for data / logs / tempdb / system

    The results from SQLIO are greater than what I calculate the array can provide because I was using 8 threads, I presume?

    Wonder what IOMeter would give?

    http://www.sqlservercentral.com/blogs/sqlmanofmystery/2011/06/29/understanding-benchmarks/%5B/url%5D

    Steve Jones - SSC Editor...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: sql server blocking and biztalk

    timscronin (10/8/2013)


    the source is hl7 sending messages to sql server tables for processing

    I can identify these but honestly BizTalk is like SharePoint with sql server, kind of a black box....

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

Viewing 15 posts - 61 through 75 (of 153 total)