October 10, 2008 at 10:01 am
I was told that we have data file issue in our database it has 86% of file system space.What to do any ideas? Not enough space on the server at all....
October 10, 2008 at 10:27 am
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
Yes, database files getting big
October 10, 2008 at 10:38 am
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply