|
Posted by Jack Vamvas on 10/02/95 11:56
One thing you can do is:
1)Full backup of db
2)DETACH db
3)change the actual name of the ONLY the log file
4)Do a REATTACH , and when the pop up occurs enter a new name for a
transaction log file. This will create a new log file
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
Make SQL Server faster - www.quicksqlserver.com
___________________________________
<yashgt@gmail.com> wrote in message
news:1156429483.730490.248020@m73g2000cwd.googlegroups.com...
> Hi,
>
> We have created a SQL server 2000 database. We observe that the
> transaction log keeps growing over time. We are now about to run out of
> space. We have been periodically shrinking the database. Nevertheless
> the size has increased. I would imagine that a transaction log can be
> eliminated if we stop the database. Can that be done? Is there a way to
> completely wipe off the transaction log?
>
> Thanks,
> Yash
>
Navigation:
[Reply to this message]
|