July 1, 2014 at 4:08 pm
Hi
I am new to Sql Server Administration activities. I have created Database which is only for staging purpose which means data will be truncated every time before loading into tables.
I am using Sql Server 2008 R2
I have created Database using the default options in SSMS and just mentioned the path of the Datafile and transaction file.
Transaction File size is growing very fast than Datafile. I am aware that there are not much to store in Transaction log when we truncate table. But log file file growing quickly.
Can you please advise if i need to specify any options while creating database?
Thanks
Nag
July 1, 2014 at 9:32 pm
Your database may be in full recovery mode. You should set it to simple recovery mode or start with a full Db backup and then perform a transaction log backup
July 2, 2014 at 2:23 am
Please take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2014 at 3:24 am
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy