|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > LOG resize in 6.5
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Srinivasa Rao 2002-11-21, 6:23 am |
| Hi,
Any body can help me to find how can I reduce the size of
the log in 6.5, I have tried Alter database with
Truncate_only but I want the space back to operating
system.
Your help is greatly appriciated.
Thanks
Srini
| |
| Tibor Karaszi 2002-11-21, 6:23 am |
| Srini,
This is not an easy task. You can deallocate fragments from your devices (with luck) using DBCC
SHRINKDB. But you cannot shrink devices. Only way would be to backup the database, create the
database now with hopefully less space and then restore.
Do NOT try this unless you are perfectly confident on how backup and restore work in 6.5 (things
like understanding the need for and the output from sp_help_revdatabase). This is a big topic,
too big for a newsgroup posting. If you don't feel confident, I recommend you hire a consultant
that can do this for you.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Srinivasa Rao" <srinivass.rao@marlborough-stirling.com> wrote in message
news:dce801c29151$d44fc010$8af
82ecf@TK2MSFTNGXA03...
> Hi,
> Any body can help me to find how can I reduce the size of
> the log in 6.5, I have tried Alter database with
> Truncate_only but I want the space back to operating
> system.
>
> Your help is greatly appriciated.
>
> Thanks
> Srini
|
|
|
|
|