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 |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2004-06-08 : 10:29:30
|
| I am trying to run a DTS package, and SQL SERVER 2000 is tellig me that I am out of space in my Database. It tells me to backup my transaction log to free up some space. any Idea on how to do this?I am not a DBA, but the closest thing we have to one.Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-08 : 10:32:26
|
| Do a full database backup... Do you know what recovery mode your database is in??After the backup, you may need to run DBCC SHRINKDATABASE or DBCC SHRINKFILE, you can find these in BOL... |
 |
|
|
mdhingra01
Posting Yak Master
179 Posts |
Posted - 2004-06-08 : 10:36:59
|
| I did a full backup 2 days ago. Recovery model is full.Can you give me the syntax for the dbcc and where do I run that from? What is BOL? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-08 : 10:45:24
|
| BOL is Books Online, your best friend when it comes to T-SQL syntax... |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-08 : 10:48:37
|
| If you do not need point in time recovery then set your recovery model to simple, this will reduce logging.-------Moo. :) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-08 : 11:01:40
|
| Anyone want to tell him to dump the log?dump the log...Brett8-) |
|
|
|
mdhingra01
Posting Yak Master
179 Posts |
Posted - 2004-06-08 : 11:06:24
|
| Will dumping the log not corrupt the DB or make it inacessible? |
|
|
|
|
|
|
Out of space