January 26, 2009 at 10:33 am
When you restore a backup, all database files will be created at the same size the database was when you backed it up.
If you want to control the transaction log size, you will have to do it in the production environment.
January 26, 2009 at 1:09 pm
if its only the log you want to shrink use the shrinkfile command instead. for just the log file.
s this statistics database updated? if so even in simple mode it will still write to the log so if you have the space might as well leave it as it is.
---------------------------------------------------------------------
January 26, 2009 at 1:23 pm
Michael Valentine Jones (1/26/2009)
When you restore a backup, all database files will be created at the same size the database was when you backed it up.If you want to control the transaction log size, you will have to do it in the production environment.
Yes that was also my thought, but I wanted to be sure.
I think we still can do some tuning as we take LOG backups every hour and our log files are sometimes still bigger than 10 GB and only use 10 percent of the space.
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply