-
Truncate transaction log through sql query analyser
Hi guys
My website is in asp and sql2000. My problem is the ISP gave access to database through query analyser. some days the transaction log is growing too high. so i want to clear it. i call up them and clear it. My question is can truncate the log file through query analyser ?
I had limited access to database.
Jini
-
BACKUP LOG database_name WITH TRUNCATE_ONLY
-
You'd better to backup log to disk for db recovery purpose.
-
Backup does not reduce the size of the transaction log file, you have to use DBCC SHRINKDATABASE or DBCC SHRINKFILE
-
dear skhanal
It is worked once. but not it not working. the error message returns "please contact your administrator"
What to do ?
jini
-
-
Everytime you run DBCC you will see
"DBCC execution completed. If DBCC printed error messages, contact your system administrator."
message, so if there is no error then you are fine.
-
yes skhanal, you are right.
err is same. but nothing is happening.
what to do ?
-
"DBCC execution completed. If DBCC printed error messages, contact your system administrator." is not error message.
-
rmiao,
then how can i solve my problem ?
-
What's your problem? Any error message?
-
Originally Posted by JINIJOSE
Hi guys
My website is in asp and sql2000. My problem is the ISP gave access to database through query analyser. some days the transaction log is growing too high. so i want to clear it. i call up them and clear it . My question is can truncate the log file through query analyser ?
I had limited access to database.
Jini
Backup log to disk for database recovery purpose.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|