I have a database device which is 1.9 gig and several transactionlog devices which vary in size. When I try to restore my database I get an error stating that my database is 4.3 gig instead of 1.9 gig. I think what SQL server is doing is counting the log size plus the data size. Now that I created this mess does anyone know how to reduce or backup the database without it counting the log size.