February 8, 2010 at 9:35 am
I want to restore a db in another server as part of the migration
db files size .mdf 367MB, .ldf 194MB, backup size 323MB.
DB size 547MB, Space avialable 50 MB
If I restore the db, the .LDF size will remain 194MB? or do i need to shrink it before taking backup?
February 8, 2010 at 9:44 am
yes, After restoring the LDF file would be 194 MB on the new server and I would leave it as it is, since it is not so huge in size. Either way, your backup is going to be roughly the same size as it is currently..
It would be not a good decision to shrink the log file on the primary server, since it would have to again to that size in future and when performing autogrow, system performance is hit and should be avoided as much as possible..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2010 at 10:36 am
laddu4700 (2/8/2010)
or do i need to shrink it before taking backup?
No point in shrinking it up. As advised just restore it normally, if the file has to grow it will grow.
February 10, 2010 at 9:01 am
Ok.
data file and log file are in same drive. Once I move the db to another server, is it okay to put both files in same drive or log file in another drive (ldf size is only 194 MB)
February 10, 2010 at 9:13 am
laddu4700 (2/10/2010)
Ok.data file and log file are in same drive. Once I move the db to another server, is it okay to put both files in same drive or log file in another drive (ldf size is only 194 MB)
SQL Server best practice is to place the data and the log files in separate disk drives..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 10, 2010 at 12:35 pm
Thanks!
May I know the reason for this?
February 10, 2010 at 12:44 pm
It incresase performance at disk level
February 10, 2010 at 2:51 pm
You increase performance by utilising the extra physical disks which reduces disks seeks and head movements.
Ideally you should keep the log on a seperate physical disks with Mirroring and look at a faster RAID level for your data files i.e. RAID1+0 or RAID5, the latter performs better with more physical disks as well.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply