Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: I tray shrink database but i have error 8985

    Thanks for your answer.

    Yes, I'm connected to my database.

    The sp_helpfile gives this answer:

    QSM_Data  1  C:\Datawatch\DBBPS\QSM_CRIPT_Data.MDF  PRIMARY 102400 KB Unlimited 10% data only

    QSM_Log    2  C:\Datawatch\DBBPS\QSM_CRIPT_Log.LDF    NULL 1451456 KB Unlimited 10% log only

    If I run the command:

    use QSM

    DBCC SHRINKFILE(QSM_log,TRUNCATEONLY)

    I have the...

Viewing post 1 (of 2 total)