-
Log and space for MSSQL2000
Hi!
I am a newbie using MSQL so please patience. I compact my database with
DATABASE SHRINK(DB,10)
BACKUP LOG data WITH TRUNCATE
DATABASE SHRINK(DB,10)
When I see the properties of my DB I see something strange
1- My log always has 1 mb of space
2- Database properties show me this information:
Size: 21639.23MB
Space Available: 782.23
Backup
Last database backup: 9/28/2007 1:44am
Last transaction log backup 6/9/2007 12:47 pm
I am so afraid because this says that I just have 782.23MB but my disk has 30GB yet.
I need to start to worry me ?
What can I do to solve this issue with my db?
TIA
-
Space available means free space in db files, not on disk. If you have enough free space on disk, don't shrink db since it's performance killer. To prevent log file grows, you should do log backup in schedule.
-
So what does mean Space Available: 782.23?
If u told me that is db file if I get this number the database does not go down? LIke I said I have enough space in my disk but this number is worry me .
-
That means the db has 782mb free space. If you let db auto grow, it'll grab space from disk when needed. Books online has details.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|