When I backup a database is there a way to exclude the transaction log in that backup? Or am I thinking about this wrong and to restore the original database the content of the transaction log is required?
I cannot shrink the transaction log because the database is using replication and I would have to break the replication.
If I issue this command and then restore the database it comes back with a 50 GB log file:
BACKUP DATABASE DatabaseName TO DISK = 'c:\temp\Database.bak'
I have to change the restored database to simple and then shrink the log file before the 50GB is freed. I cannot change the original database to simple because it is a replicated copy.