Post reply

Typical Question on sql database?

  • July 7, 2009 at 12:14 pm

    #131784

    Hi All,

    This is one of the interview question.

    Assume I have 250 GB hard disk available.

    Currently my application database say "db1" is occupying 47 GB and i have restricted the growth to 50 GB.

    Also, specified 100 MB autogrowth.

    But it is giving error. The space is not getting increased and he was asking me what could be the reason why the space is not able to increase upto 50 GB.

    Any thoughts will be greatly appreciated.

  • July 7, 2009 at 12:32 pm

    #1021271

    First question I'd ask is what is the error message? Can't diagnosis a problem from this "returned an error message".

    One possiblity, highly fragmented disk and the SQL Server couldn't get 100B of contiguous disk space. Remember it's a guess without knowing the actual error message.

  • July 7, 2009 at 1:13 pm

    #1021293

    Yaah! u r right!!!

    We should know the what error msg sql server is giving.

    Thanks!

  • July 8, 2009 at 11:37 pm

    #1022156

    Hi Lynn,

    He was expecting about the log full error.

    Thanks 🙂

  • July 8, 2009 at 11:37 pm

    #1022157

    Hi Lynn,

    He was expecting about the log full error.

    Thanks 🙂

  • July 8, 2009 at 11:39 pm

    #1022158

    Hi Lynn,

    He was expecting about the log full error.

    Thanks 🙂

  • July 8, 2009 at 11:39 pm

    #1022159

    Hi Lynn,

    He was expecting about the log full error.

    Thanks 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply