I'm Running SQL 2008 R2 server 2003. A job does a full backup daily at 5.00AM then another job runs Transaction log backups every hour using this command: -
BACKUP LOG Mydb
My problem is my LDF files keep growing (I have just had to change Recovery Model to simple and Shrink to stop my server crashing)
Does anyone know the syntax to shrink my db?
Microsoft SQL Server 2008SQL
8/22/2022 - Mon
Your help has saved me hundreds of hours of internet surfing.