Tag Info

New answers tagged

0

You should properly examine the data metrics Lengths of ip values greater than 45 SELECT IFNULL(LENGTH(ip),'Total'),COUNT(1) rowcount FROM mytable GROUP BY LENGTH(ip) HAVING LENGTH(ip) > 45 WITH ROLLUP; Suggested data type for ip using PROCEDURE ANALYSE() SELECT ip FROM mytable PROCEDURE ANALYSE(); Whatever SELECT ip FROM mytable PROCEDURE ...


2

In order for you to manage the transaction log size of your database(s) which is in full recovery mode you should be taking regular and frequent transaction log backups. The frequency should be according to RPO and RTO defined Do NOT change the recovery mode and shrink the log. You stated in your question that you didn't want any data loss by doing this ...



Top 50 recent answers are included