Home > Archive > SQL Anywhere database > June 2005 > How to set database property









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]

 

Author How to set database property
Venu

2005-06-17, 7:24 am

Hi,

Iam using ASA version 8.0.2.4361

I would like to set the database property LogName to <Drive
:\Directory\Filename
.Log>

I'd really appreciate, if you post me an appropriate sql statement to do the
above.

Thanks


Venu


Breck Carter [TeamSybase]

2005-06-17, 7:24 am

You have to stop the database normally, then run the dblog.exe utility
to specify the new log file specification.

On 17 Jun 2005 03:10:09 -0700, "Venu" <venuc@hotmail.com> wrote:

>Hi,
>
>Iam using ASA version 8.0.2.4361
>
>I would like to set the database property LogName to <Drive
> :\Directory\Filename
.Log>
>
>I'd really appreciate, if you post me an appropriate sql statement to do the
>above.
>
>Thanks
>
>
>Venu
>


--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
Venu

2005-06-17, 7:24 am

Thanks, it worked

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:7s85b19n6jpoppd
sqnitprt1q991r4nuis@
4ax.com...
> You have to stop the database normally, then run the dblog.exe utility
> to specify the new log file specification.
>
> On 17 Jun 2005 03:10:09 -0700, "Venu" <venuc@hotmail.com> wrote:
>
the[color=darkred]
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:

http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com