Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thanhtung2003
Starting Member
15 Posts |
 Posted - 2004-02-25 : 21:23:37
|
| Hi all,I have a problem...I use SQL server 2000,all the disk on computer is used to store data file and transaction log file, and now they are full so data can be insert or update because the data file and transaction log file can be add more or increase, please show me.Best regard,Hi all, |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-02-25 : 21:51:09
|
| 1. Right click on the database and choose properties.2. Click on Data File. -Is it set to Automatically Grow?3. Do the same thing for Transaction Log.4. Are you doing Transaction Backups?5. Click on Options. Tell us what you have for Recovery/Model:6. Do you have any space at all left on your hard drive?7. Try to write your problem in short, very clear statement. This will help both of us greatly and you will get help much easier here.Say one very clear thing with each sentence.Let us know the answers to each of the above and we should be able to help you pretty well.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
thanhtung2003
Starting Member
15 Posts |
Posted - 2004-02-25 : 22:26:31
|
| Hi,Data file nad transaction log file are set to Automatically Grow.But I have not any space at all left on your hard drive, please show me.Best regard,Hi all, |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-02-25 : 22:35:48
|
| Are you doing transaction log backups?If not, first set the recovery mode to simple. Second, run a dbcc shrinkdatabase('db name'). This will give you some space.Try this first. We'll go from there.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
thanhtung2003
Starting Member
15 Posts |
Posted - 2004-02-27 : 21:36:24
|
| thanks alot,Hi all, |
|
|
|
|
|
|
|
|
Disk full.