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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-09 : 10:09:55
|
| Vivek Gupta writes "Hi,I have got a database og 50Gb . The size of the database files is around 35 GB and the size of the logfile is 15 GB ..Basically now the some data is been migrated to some other database and is removed from this database .Can u please tell me how I can relaese the space from logfile and the database files from the hard disk !!!Thanksvivek" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-09 : 10:24:06
|
| Look up DBCC SHRINKDATABASE and DBCC SHRINKFILE commands in BOL. |
 |
|
|
pradeepbj
Starting Member
6 Posts |
Posted - 2002-01-15 : 11:23:57
|
| use CHECKPOINT to release some of the log spaces due.also use DBCC OPENTRAN to check if there are any open transactions which is holding up 15GB of log space. |
|
|
|
|
|
|
Shrinking the database files and the log files