I desperately need some advice from the mssql server gurus here. I'm not
the best mssql person but i do have some knowledge of database through
oracle and i'm trying to solve an urgent problem with our mssql server.
We have a table in mssql server called auditlog and this auditlog table
is taking up 7.8 GB of disk space in windows.
Environment is win2000 advanced server running mssql 2000 server.
Some wise person decided to do a bulk copy of 100 million records to
another table and this generated a lot of records. I have only 34GB hard
disk and i'm left with 10MB of space left while this operation is
running. This causes the transaction logs to fill up to 6.1 GB and a 2nd
physical datafile at 5.7GB space.
Assuming i'm happy with not rolling back and i do not have sufficient
space left to copy out the log files. Can i delete all these transaction
logs with extension .ldf and leave just the .mdb file?
When new records are added in to the database from then on, will a new
.ldf file be created for transaction log?
Else, can anyone provide ideas to solve this problem? e.g. truncate logs
command? shrink database?
In need of urgent assistance,