OldSkoolSkater
MIS
Hello All
I currently have several databases set up on our SQL server, with transaction logs that are set to unlimited growth. These log files are growing far too rapidly (one is 7Gb!!), and I am wondering if I can restrict the log file size in the DB permissions box to 500Mb without any detrimental effect?
Can it be done on a live database, or do I have to recreate the database from scratch, setting the log file restrictions at that time? (I think / hope it can be done on a live one)
Cheers
SQL Virgin
I currently have several databases set up on our SQL server, with transaction logs that are set to unlimited growth. These log files are growing far too rapidly (one is 7Gb!!), and I am wondering if I can restrict the log file size in the DB permissions box to 500Mb without any detrimental effect?
Can it be done on a live database, or do I have to recreate the database from scratch, setting the log file restrictions at that time? (I think / hope it can be done on a live one)
Cheers
SQL Virgin