Log file size 
Author Message
 Log file size

hi
i'm using sql server 6.5 nt 4 windows 95
how can i know my LOG SPACE AVAILABLE SIZE (from the vb by code) ?

        thanks Sharon



Mon, 04 Sep 2000 03:00:00 GMT
 Log file size

sql server has a system stored procedure called
sp_spaceused.  you can monitor the size of the
transaction log by running it against the syslogs table
in your database.



Quote:
> hi
> i'm using sql server 6.5 nt 4 windows 95
> how can i know my LOG SPACE AVAILABLE SIZE (from the vb by code) ?

>    thanks Sharon



Tue, 05 Sep 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Re-size Transaction Log File Size

2. transaction log fills every 30 days log file size is 500MB is this normal

3. Data File and Log File Sizes

4. How to reduce LDF log file size?

5. How to reduce my LDF log file size?

6. Changing data/log file size thru SQLDMO

7. How to reduce my LDF log file size?

8. Reduce log file size

9. How to reduce my LDF log file size?

10. log file size - can't shrink

11. Reallocating Log File Size

12. Log File size to large.


 
Powered by phpBB® Forum Software