Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: dbcc checkdb Error

    failed with the following error: "Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8800782319616 (type Unknown), page (40498:1). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values...

  • RE: DBCC Shrink Log file in Database is read only in sql2005

    Use Databse name

    ALTER DATABASE database-name SET READ_WRITE

    and then run the DBCC Shrinkfile('Logfilename', Size)

    Take the Full backup.

    And then

    ALTER DATABASE database-name SET READ_ONLY

    there is only option if you want to shrink the...

  • RE: Database in Recovery Pending State

    Hey Guys Nothin to do....

    Chek firs mdf and ldf is exist or not..

    if exist run below coommand on master DB

    ALTER DATABASE 'DATBASE NAME' SET OFFLINE WITH ROLLBACK IMMEDIATE

    ALTER DATABASE 'DATBASE...

Viewing 3 posts - 1 through 3 (of 3 total)