-axapta] (urgent) how to delete log file from
SQL
server 2000
First i want to thank for all replies;
But i couldn't solve problem, when i shrink db, the physical file size
is not getting smaller. How can i get it smaller?
Thanks in advance.
Yahoo! Groups Sponsor
ADVERTISEMENT
Hi Cenk Ince,
If your log file is not being used to trace any transaction into database, then you may use backup with truncate using the command backup log and then shrink the log file using dbcc shrink file command.
The following script is to truncate all databases' log file. You can put the
:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 9:03 AM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] (urgent) how to delete log file from SQL
server 2000
First i want to thank for all replies;
But i couldn't solve problem, when i shrink db, the physical file size
is not ge
First i want to thank for all replies;
But i couldn't solve problem, when i shrink db, the physical file size
is not getting smaller. How can i get it smaller?
Thanks in advance.
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the we
t; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 01, 2004 3:25 AM
Subject: RE: [development-axapta] (urgent) how to delete log file from SQL
server 2000
> Don't ever delete the log file!!! :-(
>
> Myrl
>
>
>
> -Original Message-
&g
delete log file from
SQL server 2000
Don't ever delete the log file!!! :-(
Myrl
-Original Message-
From: Cenk Ince [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 2:23 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] (urgent) how to delete log file from SQL
server
ld
explain things fairly okay).
-Original Message-
From: Myrl Stadnick [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 5:25 AM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] (urgent) how to delete log file from SQL
server 2000
Don't ever delete the log fil
Don't ever delete the log file!!! :-(
Myrl
-Original Message-
From: Cenk Ince [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 2:23 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] (urgent) how to delete log file from SQL
server 2000
Hi all;
I want to delete l
Create a job under Management in Enterprise manager.
With StepName: truncate
Type: Transact-SQL Script (TSQL)
Database: AXDB (Your Database)
Command: Backup Log AXDB with Truncate_only DBCC Shrinkfile
(AXDB_Log,1)
Hope this Helps.
Myrl
H
9 matches
Mail list logo