Post reply

Data file issue, please help me

  • October 10, 2008 at 10:27 am

    #883536

    Not sure what you mean. If you mean the database files are getting too big you can try shrinking the database. If the log file is very large you can back it up and shrink it.

  • October 10, 2008 at 10:29 am

    #883538

    Yes, database files getting big

  • October 10, 2008 at 10:38 am

    #883543

    Have a look in books online at the dbcc command, you can shrink a file or database using it. If the log file is too large do a transaction log backup and then shrink the file but if it is the transaction log then the backup will need to be done regularly - see the recovery models in books online.

    If the data files are getting too big and you've looked into the above then you may need to get more disk space.

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

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