Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-07 : 09:51:33
|
| Akshay Dubey writes "Dear Sir , I am working in a software company in India, we are working on VB-Sql server2000 combination. At our client end we maintain two server one is our local server and another is RAS server. The first one is where data is stored after all transaction . We need to transferthe data from our local server to RAS server to maintain thewebsite (devloped using ASP) on intranet. We tried the replication facility. The transfer was succesful but after transfering the size of log file increses toaround 11 GB against 3GB of data file. We took the backup of log file , due to which size reduces. But it was not fisible and I want the proper reason and removal of the problem. Wheather Indexing on database effect the size o flog file.Thanking YouIn waiting for quick replyAkshay DubeyOswal Data ProcessorsIndore, India" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-07 : 10:16:58
|
| Log file sizing, growth and management will become far less mysterious if you read about how they work in Books Online.SQL Server (per Codds rules) preserved transactional integrity. Replication is a lot of transactions. This results in log file growth. There are many built in DBA tools to manage this process.Jay White{0} |
 |
|
|
|
|
|
Increase Of Transaction Log After Data Import Operation