asp_databases thread: Urgent!newbie for sql6.5: cleaning up logs in database?
Message #1 by "Eric Van Camp" <eric@a...> on Wed, 20 Jun 2001 10:12:37 +0200
|
|
Apparantly sql 6.5 and others use the tempdb to store their results in
of a query you run against the database..
now this tempdb is to small, i can expand it..no prob, BUT how do i
clean up the logs in sql server 6.5??
Met Vriendelijke groet,
Eric Van Camp
Atmilestone BVBA
Trolieberg 74
3010 Kessel-lo
Tel:016/35.69.99
Fax:016/35.57.90
eric@a... <mailto:eric@a...>
<http://www.atmilestone.be/>
Message #2 by Gee Vee <happygv@y...> on Wed, 20 Jun 2001 01:49:10 -0700 (PDT)
|
|
Use the SQL statement "Dump Tran" with the option "no
log" which will clear your log. This can be done for
each database seperately.
Please refer to the Syntax in Books online Help for
the sql version and let me know whether it solved your
purpose.
regards
Vijay.G
Message #3 by "Eric Van Camp" <eric@a...> on Wed, 20 Jun 2001 12:52:26 +0200
|
|
thanks this helped!
the correct syntax was dump transaction ameel with no_log
ameel being the database!
-----Original Message-----
From: Gee Vee [mailto:happygv@y...]
Sent: Wednesday, June 20, 2001 10:49
To: ASP Databases
Subject: [asp_databases] Re: Urgent!newbie for sql6.5: cleaning up logs
in database?
Use the SQL statement "Dump Tran" with the option "no
log" which will clear your log. This can be done for
each database seperately.
Please refer to the Syntax in Books online Help for
the sql version and let me know whether it solved your
purpose.
regards
Vijay.G
|
View Cart
