I have a database that has never had the transaction log backed up. Therefore, it is 40GB in size, where the database file is about 750MB. I've asked our VM guys to increase the size of the drive by 50GB to account for growth in the database file when I backup the transaction log.
My plan is to:
1. Backup the database to a remote directory (not on the server).
2. Backup the log file to a remote location.
3. Srink the log file to recover disk space.
Any thoughts or advice? I've been away from SQL Servers for awhile.